select temp1.f1,temp1.f2,temp1.f3,temp1.f4,temp2.f5,temp2.f6
from table
lateral view json_tuple(f0,'f1','f2','f3','f4') temp1
as f1,f2,f3,f4
lateral view json_tuple(f4,'f5','f6') temp2
as f5,f6;
[数据分析][Hive]json_tuple()解析嵌套json
于 2021-04-13 21:02:50 首次发布