v.23.3New Feature

Add mapFromArrays function for creating maps from array pairs

Add the Map-related function mapFromArrays, which allows the creation of a map from a pair of arrays. #31125 (李扬).
Introduced the function mapFromArrays in ClickHouse to create a map from two arrays, one representing keys and the other values.

Why it matters

This feature solves the problem of easily constructing map data structures from separate key and value array inputs, enabling users to efficiently pair corresponding elements into maps for flexible data processing and querying.

How to use it

Use the function mapFromArrays(keys_array, values_array) where keys_array is an array of keys and values_array is an array of values. The function returns a map combining these corresponding elements.