v.1.1.54245New Features

Engine for Dictionary Tables Access

Official CH changelog text
The engine for Dictionary tables (access to dictionary data in the form of a table).
Introduces a new table engine in ClickHouse that allows accessing dictionary data as if it were a regular table, enabling easier querying and integration with SQL features.

Why it matters

This feature solves the problem of limited flexibility when working with dictionaries in ClickHouse by providing direct SQL table access to dictionary data. It simplifies querying, joins, and transformations by leveraging the familiar table interface instead of using dictionary functions, thus improving usability and integration in analytical workflows.

How to use it

To use the engine for dictionary tables, you create a table using the new engine and specify the dictionary name. This allows the dictionary data to be queried as a regular table. For example:

CREATE TABLE dictionary_table_name ENGINE = Dictionary('dictionary_name')

After this, you can perform SELECT queries and joins on this table as with any other ClickHouse table.

Related resources

PreviousNext