v.22.2Improvement
Allow parsing dictionary's PRIMARY KEY as PRIMARY KEY (id, value)
Allow to parse dictionary'sPRIMARY KEYasPRIMARY KEY (id, value); previously supported onlyPRIMARY KEY id, value. Closes #34135. #34141 (Maksim Kita).
Why it matters
Previously, dictionary definitions in ClickHouse only acceptedPRIMARY KEY declarations without parentheses, which limited syntax flexibility and clarity. This feature improves dictionary schema definition parsing by allowing a more standard and explicit syntax for composite primary keys, making dictionary configurations more intuitive and easier to read.How to use it
When defining a dictionary, use thePRIMARY KEY clause with parentheses around column names for composite keys, like this:PRIMARY KEY (id, value)This replaces the previous syntax that omitted parentheses.