map
(key1, value1, key2, value2, …) Creates a map with the given key/value pairs
select
map("a", 1, "b", 2, "c", "dd") as m1,
map("a", 1, "b", 2, "c", 3) as m2,
map(1, 1, 2, 2, 3, 3) as m2
返回
| m1 map | m2 map | m1 map |
|---|---|---|
| {“a”:“1”,“b”:“2”,“c”:“dd”} | {“a”:1,“b”:2,“c”:3} | {“1”:1,“2”:2,“3”:3} |
select
map("a", 1, "b", 2, "c", "dd")['a'] as v1,
map("a", 1, "b", 2, "c", 3)['a'] as v2,
map(1, 1, 2, 2, 3, 3)[1] as v3
Map类型长度函数: size(Map
select
size(map("a", 1, "b", 2, "c", "dd")) as v1,
size(map("a", 1, "b", 2, "c", 3)) as v2,
size(map(1, 1, 2, 2, 3, 3)) as v3
