SELECT id
,get_json_object(get_json_object(operate_content,'$.finishTime'),'$.n')
,get_json_object(operate_content,'$.finishTime.n')
FROM dw.dw_plat_sinan_ticket_operate_record_da
WHERE pt='20200730000000'
and id='1112167'
hiveSQL之json多层嵌套解析的方法
最新推荐文章于 2024-08-18 11:54:36 发布