知识点一:
explode(split(get_json_object(fieldDataName,’$.str’),’,’))
1、fieldDataName表示数据库字段名;
2、$.str表示要从数据库定中JOSN类型的字段中取的内容
使用到的命令包括:
1、get_json_object :从JSON中取值;
get_json_object,多层JSON的取值
data =
{
"store":
{
"fruit":[{"weight":8,"type":"apple"}, {"weight":9,"type":"pear"}],
"bicycle":{"price":19.95,"color":"red"}
},
"email":"amy@only_for_json_udf_test.net",
"owner":"amy"
}
1.1、.get单层值
hive> select get_json_object(data, ‘$.owner’) from test;
结果:amy
1.2.get多层值.
hive> select get_json_object(data, ‘$.store.bicycle.price’) from test;
结果:19.95
1.3.get数组值[]
hive> select get_json_object(data, ‘$.store.f