hive ----获取json字符串中指定字段名的值

hive ----获取json字符串中指定字段名的值 idinfo1{"con_id":"105","doctor_id":"134"}2{"con_id":"107","status":"True"}

 

select get_json_object(info,'$.con_id') from test

运行结果：

info105107