我有一个如下所示的 Json 数组
[{"Name":"xxxx","Machine":"Machine1"},{"Name":"yyyy","Machine":"Machine2"},{"Name":"zzzz","Machine":"Machine3"}]
我需要解析该数据并加载到如下所示的配置单元表中
Name Machine
xxxx Machine1
yyyy Machine2
zzzz Machine3
有人可以帮忙吗?
select j.Name,j.Machine
from jsonarray t
lateral view explode(split(substr(t.json,2),'(?<=\\}),(?=\\{)')) e
lateral view json_tuple(e.col,'Name','Machine') j as Name,Machine
;
+------+----------+
| name | machine |
+------+----------+
| xxxx | Machine1 |
| yyyy | Machine2 |
| zzzz | Machine3 |
+------+----------+
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)