MAP_KEYS (Lakehouse v2)

Returns all keys from a map as an array.

Analyze Syntax

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

Analyze Examples

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

┌───────────┐
│ ['a','b'] │
└───────────┘

SQL Syntax

MAP_KEYS(<map_col>)

SQL Examples

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

┌───────────┐
│ ["a","b"] │
└───────────┘