在HIVE中对JSON进行解析

在HIVE中对JSON进行解析

get_json_object

[{"name":"dxd","age","21"},{"name":"ddd","age":"22"}]

1、取出第一个JSON对象；
Using: get_json_object('[{"name":"dxd","age","21"},{"name":"ddd","age":"22"}]','$[0]')
Result: {"name":"dxd","age","21"}

2、取出第一个JSON的name字段的值；
Using: get_json_object('[{"name":"dxd","age","21"},{"name":"ddd","age":"22"}]','$[0].name')
Result: 21