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. All keyN must share a least common type.
• valueN: An expression of any type. All valueN 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}

Related

• [ ] operator
• map_concat function
• map_entries function
• map_filter function
• map_from_arrays function
• map_from_entries function
• map_keys function
• map_values function
• map_zip_with function
• SQL data type rules