1、hive 字符串操作:https://www.cnblogs.com/iiwen/p/5611761.html
2、参考https://blog.csdn.net/u010670689/article/details/72885944
https://blog.csdn.net/inte_sleeper/article/details/7196114
3、https://www.cnblogs.com/30go/p/9484836.html
select username,ai.id,ai.age,p.uname,p.code from test1
lateral view json_tuple(actioninfo,'id','age','partlist') ai as id,age,partlist
lateral view explode(split(regexp_replace(regexp_extract(partlist,'^\\[(.+)\\]$',1),'\\}\\,\\{', '\\}\\|\\|\\{'),'\\|\\|')) partlist as p
lateral view json_tuple(p,'code','uname') p as code,uname
4、对里面操作做详细解释: