Share via

map_from_arrays function

  • Article

Applies to: check marked yes Databricks SQL check marked yes 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.

Examples

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