hive> select get_json_object('{
? ? >? "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"
? ? > }','$.store.fruit[0].weight');
OK
8
Time taken: 0.141 seconds, Fetched: 1 row(s)
hive> select get_json_object('{
? ? >? "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"
? ? > }','$.store.fruit[1].type');
OK
pear
hive> select get_json_object('{
? ? >? "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"
? ? > }','$.store.fruit.type');
OK
["apple","pear"]
Time taken: 0.137 seconds, Fetched: 1 row(s)
get_json_object中對于外層的直接'$.key.key[index].key2'; index對應(yīng)數(shù)組中第幾個json,key2對應(yīng)數(shù)組中json的key;
