map
function
Applies to: Databricks SQL Databricks Runtime
Creates a map with the specified key-value pairs.
Syntax
map( [key1, value1] [, ...] )
Arguments
keyN
: An expression of any comparable type. AllkeyN
must share a least common type.valueN
: An expression of any type. AllvalueN
must share a least common type.
Returns
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.
Examples
> SELECT map(1.0, '2', 3.0, '4');
{1.0 -> 2, 3.0 -> 4}