每天一点点,记录工作中实操可行
hive json数组解析
hive中有字段A长这个样子,想把其中的name值全部解析出来
[{"itemRateId":"73288842","name":"东北有机大米饭","rating":4,"ratingContent":""},{"itemRateId":"73288850","name":"需要餐具","rating":4,"ratingContent":""},{"itemRateId":"73288834","name":"辣跳冒牛百叶","rating":4,"ratingContent":""},{"itemRateId":"73288826","name":"金汤酸菜鱼套餐(鱼+配菜+小菜+米饭)-现炸酥肉(+10元)","rating":4,"ratingContent":""}]
1: get_json_object 每次只能解析一个字段,但我不知道每个字段A到底有多少个name的键值对,不可能挨个解析,所以。。。。。
select get_json_object(被解析字段A,"$.[0].name") column_name
from table_name
结果,只把第一个name值解析出来了
劲爽金汤酸菜鱼