MAP_VALUES (Lakehouse v2)

Returns all values from a map as an array.

Analyze Syntax

func.map_values(get_column(table, 'map_col'))

Analyze Examples

func.map_values(MAP{'a':1,'b':2})

┌───────┐
│ [1,2] │
└───────┘

SQL Syntax

MAP_VALUES(<map_col>)

SQL Examples

SELECT MAP_VALUES(MAP{'a':1, 'b':2});

┌───────┐
│ [1,2] │
└───────┘