map_from_arrays function

Applies to: Databricks SQL Databricks Runtime

Creates a map with a pair of the keys and values arrays.

Syntax

map_from_arrays(keys, values)

Arguments

• keys: An ARRAY expression without duplicates or NULL.
• values: An ARRAY expression of the same cardinality as keys

Returns

A MAP where keys are of the element type of keys and values are of the element type of values.

Azure Databricks raises DUPLICATED_MAP_KEY if keys contains duplicates.

Common error conditions

• DUPLICATED_MAP_KEY

Examples

> SELECT map_from_arrays(array(1.0, 3.0), array('2', '4'));
 {1.0 -> 2, 3.0 -> 4}

> SELECT map_from_arrays(array(1, 1), array('a', 'b'));
  Error: DUPLICATED_MAP_KEY

Related functions

• map function
• map_concat function
• map_entries function
• map_filter function
• map_from_entries function
• map_keys function
• map_values function
• map_zip_with function