hive 将json格式的字符串取值或转为map格式

1. 取值：

SELECT get_json_object(字段名,'$.json_key_value')

--,
--get_json_object(get_json_object(ad_test_group,'$.2019-09-cid2_1342_1276'),'$.group_id')
from 
table_name
where dt= '2019-09-21' 

 

2. string 转 map

select pt_day,uid,point,str_to_map(regexp_replace(regexp_replace(regexp_replace(extra_info,'\"',''),'\\{',''),'\\}',''), ',', ':') extra_info
from honeycomb_all_user_point_record
where pt_day between '2018-11-16' and '2018-11-24' 
  and type=2 and action=2001

参考链接：https://blog.csdn.net/BabyFish13/article/details/84858144