Support for Dictionary Management in clickhouse-local with DDL Queries

Why it matters

These improvements address gaps in dictionary management by enabling dictionary creation directly in clickhouse-local, allowing permanent detachment of dictionaries to better control lifecycle, facilitating dictionary swapping in Atomic databases for atomic operations, and enabling dictionary relocation across databases. Together, these features make dictionary administration more flexible, powerful, and aligned with enterprise needs.

How to use it

To create dictionaries in clickhouse-local, use standard DDL CREATE DICTIONARY queries as you would in the server. Use DETACH DICTIONARY PERMANENTLY to detach a dictionary irreversibly. For atomic dictionary swapping in the Atomic engine, use EXCHANGE DICTIONARIES. To move a dictionary between databases, use RENAME DICTIONARY specifying the target database.