v.18.12New Feature

Added Support for UInt, Int, and DateTime as Range Hashed External Dictionary Keys

Official CH changelog text
Added the ability to use UInt*, Int*, and DateTime data types (along with the Date type) as a range_hashed external dictionary key that defines the boundaries of ranges. Now NULL can be used to designate an open range. Vasily Nemkov
Added support for UInt*, Int*, and DateTime data types, in addition to Date, as range_hashed external dictionary keys to define range boundaries. This update enables the use of NULL to represent open ranges.

Why it matters

This feature enhances the flexibility of range_hashed external dictionaries by allowing a wider variety of data types as range boundaries, including signed and unsigned integers and datetime types. It solves the problem of limited data type support for range keys and introduces the ability to specify open-ended ranges using NULL, thereby improving range querying capabilities and usability for users working with diverse data.

How to use it

To use this feature, define your external dictionary with the range_hashed layout and specify UInt*, Int*, or DateTime as the key data types that represent range boundaries. Use NULL values in the key columns to indicate open ranges in the dictionary definition.

Related resources

PreviousNext