DISTINCT_MAP_KEYS

Returns the distinct keys from a map.

Analyze Syntax

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

Analyze Examples

func.distinct_map_keys(get_column(table, 'tags'))

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

SQL Syntax

DISTINCT_MAP_KEYS(<map_col>)

SQL Examples

SELECT DISTINCT_MAP_KEYS(MAP{'a':1, 'b':2, 'c':3});

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