hive json-get_json_object和json_tuple

来源：互联网发布：魔戒最后之日修改数据编辑：程序博客网时间：2024/05/18 11:28

字段值

{"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

阅读全文

0 0