map_from_entries function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Creates a map created from the specified array of entries.

Syntax

map_from_entries(expr)

Arguments

  • expr: An ARRAY expression of STRUCT with two fields.

Returns

A MAP where keys are the first field of the structs and values the second. There must be no duplicates or nulls in the first field (the key).

Examples

> SELECT map_from_entries(array(struct(1, 'a'), struct(2, 'b')));
 {1 -> a, 2 -> b}