map_values function

Applies to: Databricks SQL Databricks Runtime

Returns an unordered array containing the values of map.

Syntax

map_values(map)

Arguments

• map: A MAP expression.

Returns

An ARRAY where the element type matches the map value type.

Examples

> SELECT map_values(map(1, 'a', 2, 'b'));
 [a,b]

Related functions

• [ ] (bracket sign) operator
• map function
• map_concat function
• map_entries function
• map_filter function
• map_from_arrays function
• map_from_entries function
• map_keys function
• map_zip_with function