Categories: Semi-Structured Data

MAP_VALUES

Returns all values from a map expression.

Syntax

MAP_VALUES(input map) → array

• input: A map expression for which to return an array of values.

Examples

MAP_VALUES example

SELECT MAP_VALUES(properties)
-- ['Hardcover', '2002', 'Blue']

MAP_VALUES example returning literal map values

SELECT MAP_VALUES(MAP_Col) FROM (SELECT MAP['a','1', 'b', '2'] as MAP_Col)
-- ['1', '2']