v.19.16New Feature
Support Redis as Source of External Dictionary
Support Redis as source of external dictionary. #4361 #6962 (comunodi, Anton Popov)
Why it matters
This feature allows users to directly use Redis key-value stores as external dictionaries in ClickHouse, facilitating real-time and efficient data lookups from Redis without complex ETL processes, thereby improving performance and data integration workflows.How to use it
To use Redis as a source for an external dictionary, define a dictionary configuration in XML or via the dictionary definition that specifies Redis as the source type and provides connection details (host, port, database, password). Then, refer to the dictionary in your queries for lookups. For example, specifyredis as source type and set parameters like host, port, and db.