HIVE map

map 构造函数

map
(key1, value1, key2, value2, …) Creates a map with the given key/value pairs

demo

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<string,string>	m2 map<string,int>	m1 map<int,int>
{“a”:“1”,“b”:“2”,“c”:“dd”}	{“a”:1,“b”:2,“c”:3}	{“1”:1,“2”:2,“3”:3}

获取 某个key值

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<k .v>)

  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