炸裂函数与正则替换

炸裂函数

 lateral view explode 可以对数组进行炸裂；也可以对map进行炸裂

 

 

对map字段进行炸裂：lateral view explode(map字段) aa as ikey1,ivalue1;

 

对数组字段进行炸裂：lateral view explode(数组字段) aa as 字段1;

 

lateral view explode(split(regexp_replace(regexp_replace(regexp_replace(regexp_replace(regexp_replace(substring(
json字段,2,length(json字段)-2),'\\\\},\\\\{','\\\\}\\\\|\\\\{'),',\"','\\\\~\"'),'\"',''),'\\\\{',''),'\\\\}',''),'\\\\|')) aa as 字段1