MAP_VALUES
Learn how to use the MAP_VALUES map function in PlaidCloud Lakehouse. Returns all values from a map as an array - see syntax, examples, and output.
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] │
└───────┘