MAP_VALUES
Description
Extract the values of the given map into an ARRAY of the corresponding type
Syntax
MAP_VALUES(<map>)Parameters
| Parameter | Description |
|---|---|
<map> | Input map content |
Return Value
Extract the values of the given map into an ARRAY of the corresponding type
Example
select map_values(map()),map_values(map(1, "100", 0.1, 2));+-------------------+---------------------------------------------------------------------------------------------------+
| map_values(map()) | map_values(map(cast(1 as DECIMALV3(2, 1)), '100', cast(0.1 as DECIMALV3(2, 1)), cast(2 as TEXT))) |
+-------------------+---------------------------------------------------------------------------------------------------+
| [] | ["100", "2"] |
+-------------------+---------------------------------------------------------------------------------------------------+