hive json-get_json_object和json_tuple

字段值

{"data"："DISCOVER_GOODS_SHOW_190E_STAERT####
{\"gid\"：\"F686ADB9-38AB-F907-9D8C-14DFAF53FFFE\",
\"vid\"：\"80011136\",
\"cid\"：\"C1001\",
\"uid\"：\"CC47846D-10D3-44E2-8A44-D04A5BC65B65\",
\"pid\"：\"10010\",
\"page\"：\"discoverGoods\",
\"poiCity\"：\"\",
\"requestId\"：\"\",
\"module\"：\"\",
\"source\"：\"\"}
####DISCOVER_GOODS_SHOW_190E_END"}

解析：

select get_json_object(type,'$.page') from 

(select regexp_replace(regexp_replace(split(action,'####')[1],'\\\\\\\\',''),'：',':')type from ods_client_behavior_hour4spark where dt ='2017-06-11' and lower(action) like  lower('%DISCOVER_GOODS_CLICK_9E8D_STAERT%' ))a
 limit 100


 
 select json_tuple(type,'page','module','clickPos','clickName') from 
(select regexp_replace(regexp_replace(split(action,'####')[1],'\\\\\\\\',''),'：',':')type from ods_client_behavior_hour4spark where dt ='2017-06-11' and lower(action) like  lower('%DISCOVER_GOODS_CLICK_9E8D_STAERT%' ))a
 limit 100