v.21.11Improvements

Function has: Added Map data type support

Function has: added support for Map data type. #29267 (Maksim Kita).
The has function in ClickHouse now supports the Map data type.

Why it matters

This feature extends the has function to work with the Map data type, enabling users to check for the presence of keys within Map columns efficiently. It enhances querying capabilities when working with complex data types.

How to use it

You can use the has function directly on Map type columns to check if a given key exists. For example:

SELECT has(map_column, 'key_to_check') FROM table_name;