hiveSQL之json多層嵌套解析的方法

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'