`map` function

Applies to: Databricks SQL Databricks Runtime

Creates a map with the specified key-value pairs.

Syntax

map( [key1, value1] [, ...] )

keyN: An expression of any comparable type. All keyN must share a least common type.
valueN: An expression of any type. All valueN must share a least common type.

A MAP with keys typed as the least common type of keyN and values typed as the least common type of valueN.

There can be 0 or more pairs.

If there is a duplicate key or a NULL key the function raises an error.

SQL
> SELECT map(1.0, '2', 3.0, '4');
 {1.0 -> 2, 3.0 -> 4}