一、hive生成json及解析
生成json
select concat('{\"create_date\":\"',a.create_date,'\",\"mode\":\"',a.mode,'\",\"resident_province\":\"',a.resident_province,'\",\"province_amount\":\"',a.province_amount,'\",
\"rate1\":\"',a.rate1,'\"}') as value from lab_apply_moniter_pro_stats a
方法1:
解析json
使用get_json_object函数解析该json数据:
select get_json_object(t.json_line, '$.id'),
get_json_object(t.json_line, '$.index_date'),
get_json_object(t.json_line, '$.index_name'),
get_json_object(t.json_line, '$.index_value')
from tbl_test_json t;
方法2:
insert into yx_rc_tmp.tmp_fk_ods_38_rmisbussapply (orderid,id,name,phone,dt)
select a.orderid,b.id,b.name,b.phone,a.dt from fk_ods_38_rmisbussapply