hive json tuple用法 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