v.21.9New Feature

Added complex_key_range_hashed dictionary, closes #22029

Added complex_key_range_hashed dictionary. Closes #22029. #27629 (Maksim Kita).
Introduced the complex_key_range_hashed dictionary type in ClickHouse for enhanced dictionary lookups using complex key ranges.

Why it matters

This feature addresses the need for efficient dictionary queries based on complex key ranges, improving performance and flexibility when working with dictionaries that require hashed indexing on composite keys.

How to use it

To use this feature, define a dictionary in ClickHouse with the complex_key_range_hashed layout in the dictionary configuration file, specifying the structure and keys accordingly. This enables hashed lookups on complex key ranges in dictionary queries.