map_from_entries function

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

Azure Databricks raises DUPLICATED_MAP_KEY if there are duplicate keys.

Common error conditions

• DUPLICATED_MAP_KEY

Examples

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

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

Related functions

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