v.22.8Improvement
Allow Hash Functions to Accept Map Type Arguments
Allow to execute hash functions with arguments of type Map. #39685 (Anton Popov).Why it matters
This feature enables users to apply hash functions directly toMap data types, which previously were unsupported. It enhances the flexibility and functionality of hash operations in queries involving complex data structures.How to use it
Users can now pass columns or expressions of typeMap as arguments to hash functions without additional conversions or workarounds. Simply use the hash function as usual, for example: SELECT cityHash64(my_map_column) FROM table.