v.25.5Improvement

Support NULLs

Official CH changelog text
Hash functions now support NULLs inside arrays, tuples, and maps. (issues #48365 and #48623). #79008 (Michael Kolupaev).
Hash functions in ClickHouse now properly support NULL values inside complex data types such as arrays, tuples, and maps.

Why it matters

This feature addresses issues where hash functions failed or produced incorrect results when encountering NULL values inside arrays, tuples, or maps. By supporting NULLs, users can reliably perform hashing operations on complex nested data containing missing or undefined values, improving data integrity and query correctness.

How to use it

No special configuration is needed to use this feature. When applying hash functions to arrays, tuples, or maps that contain NULL values, the functions will now handle NULLs correctly automatically.

Related resources

PreviousNext