采用json_tuple(str1,’str2’),其中str1是表中的字段名,str2是要提取的json中某个数据key值。
具体使用方法:
select
str5,
str4,
str3,
str2
from channel_anti.sdk_blh_android_normal_quarter lateral view json_tuple(data,'str1') b as str5
select
str5,
str4,
str3,
str2
from channel_anti.sdk_blh_android_normal_quarter lateral view json_tuple(data,'str1') b as str5