select * from employee lateral view explode(work_place) a as loc;
表名为employees,explode是函数把数组拆分,work_place是字段,loc是新的字段名,lateral view是侧视图
select * from employee lateral view explode(work_place) a as loc;
表名为employees,explode是函数把数组拆分,work_place是字段,loc是新的字段名,lateral view是侧视图