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).
Added a new complex_key_direct layout for ClickHouse dictionaries that avoids local storage during query execution.

Why it matters

The complex_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 the complex_key_direct layout in its configuration. This instructs ClickHouse to execute dictionary queries without storing intermediate data locally, enabling direct key lookups.