,\{’) as str
from
(
select ‘[{a:1,b:1},{a:2,b:2},{f:6,k:7}]’ as appinfo
) a
) pp
lateral view explode...b:1}
{a:2,b:2}
{f:6,k:7}
操作详解:
1.regexp_extract(a.appinfo,’^\[(.+)\]$’,1) 替换掉中括号
2.split函数拆分成数组,分隔符为...’\}\,\{’,其实就是},{
3.lateral view explode 行转列
4.使用},{为分隔符,补全前后缺失的{和}
get_json_object函数:
select get_json_object