v.20.1New Feature

Add ON CLUSTER Support for CREATE DICTIONARY Queries

Add ability to execute CREATE DICTIONARY queries in ON CLUSTER mode. #8163 (alesapin)
Add support for executing CREATE DICTIONARY queries with ON CLUSTER clause to create dictionaries cluster-wide.

Why it matters

This feature allows users to create dictionaries simultaneously on all nodes of a ClickHouse cluster using a single CREATE DICTIONARY ON CLUSTER command. It simplifies cluster management by ensuring dictionary definitions are consistent across all nodes and reduces manual effort.

How to use it

Use the CREATE DICTIONARY statement with the ON CLUSTER 'cluster_name' clause to create a dictionary on all nodes in the specified cluster. For example:

CREATE DICTIONARY dictionary_name ON CLUSTER 'cluster_name' (...) SETTINGS ...;