Skip to main content

MAP_VALUES

Introduced or updated: v1.2.429

Returns the values in a map.

Syntax​

MAP_VALUES( <map> )

Arguments​

ArgumentsDescription
<map>The input map.

Return Type​

Array.

Examples​

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

┌─────────────────────────────────┐
│ map_values({'a':1,'b':2,'c':3}) │
├─────────────────────────────────┤
│ [1,2,3] │
└─────────────────────────────────┘
Try Databend Cloud for FREE

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.

Sign up and get $200 in credits.

Try it today