map_entries function

Applies to: Databricks SQL Databricks Runtime

Returns an unordered array of all entries in map.

Syntax

map_entries(map)

Arguments

• map: A MAP expression.

Returns

An ARRAY of STRUCTs holding key-value pairs.

Examples

> SELECT map_entries(map(1, 'a', 2, 'b'));
  [{1, a}, {2, b}]

Related functions

• [ ] (bracket sign) operator

• map function

• map_concat function

• map_from_entries function

• map_filter function

• map_from_arrays function

• map_keys function

• map_values function

• map_zip_with function