v.20.1New Feature
Add ON CLUSTER Support for CREATE DICTIONARY Queries
Add ability to executeCREATE DICTIONARYqueries inON CLUSTERmode. #8163 (alesapin)
Why it matters
This feature allows users to create dictionaries simultaneously on all nodes of a ClickHouse cluster using a singleCREATE 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 theCREATE 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 ...;