v.20.5New Feature
Added complex_key_direct layout to dictionaries for non-local query execution
Added new complex_key_direct layout to dictionaries, that does not store anything locally during query execution. #10850 (Artem Streltsov).Why it matters
Thecomplex_key_direct layout addresses scenarios where dictionary queries should not rely on local caching or storage, reducing memory overhead and potentially improving performance for certain use cases where on-the-fly data retrieval is preferred.How to use it
To use this feature, define a dictionary with thecomplex_key_direct layout in its configuration. This instructs ClickHouse to execute dictionary queries without storing intermediate data locally, enabling direct key lookups.