MAP_VALUES
Updated at:
Returns all values in Map a as an array.
Syntax
array<V> map_values(map<K, V> <a>)Parameters
a: required. This parameter specifies a map. K and V in map<K, V> specify the keys and values of a map.
Return value
A value of the ARRAY type is returned. If the input map is null, null is returned.
Examples
Return all keys in a map based on the data in the t_table_map table that contains the c1 (BIGINT) and t_map (MAP<STRING,BIGINT>) columns. Data in the table:
+------------+-------+
| c1 | t_map |
+------------+-------+
| 1000 | {k11:86, k21:15} |
| 1001 | {k12:97, k22:2} |
| 1002 | {k13:99, k23:1} |
+------------+-------+Sample statement:
-- Return values in the t_map column as an array.
select c1,map_values(t_map) from t_table_map;
-- The following result is returned:
+------------+------+
| c1 | _c1 |
+------------+------+
| 1000 | [86, 15] |
| 1001 | [97, 2] |
| 1002 | [99, 1] |
+------------+------+Related functions
MAP_VALUES is a complex type function. For more information about the functions that are used to process data of complex data types, such as ARRAY, MAP, STRUCT, and JSON, see Complex type functions.
Is this page helpful?