MAPVALUES
Returns a string representation of the top-level values from a VMap. This transform function requires an over()
clause.
Syntax
MAPVALUES(VMap_data)
Arguments
VMap_data |
The VMap from which values should be returned. The VMap can exist as:
|
max_value_length
|
In a __raw__ column, specifies the maximum length of values the function can return. Values that are larger than max_value_length cause the query to fail. Defaults to the smaller of VMap column length and 65K. |
Examples
The following example shows how to query a darkmountain
flex table, using an over()
clause (in this case, the over(PARTITION BEST)
clause) with mapvalues()
.
=> SELECT * FROM (SELECT MAPVALUES(darkmountain.__raw__) OVER(PARTITION BEST) FROM darkmountain) AS a; values --------------- 29029 34.1 Everest mountain 29029 15.4 Mt St Helens volcano 17000 12.2 Denali mountain 14000 22.8 Kilimanjaro mountain 50.6 Mt Washington mountain (19 rows)
Specify the Maximum Length of Values that MAPVALUES Can Return
=> SELECT MAPVALUES(__raw__ USING PARAMETERS max_value_length=100000) OVER() FROM mapper; keys ------------- five_Map four one six three_Array two (6 rows)