行列互转-lateral view、explode、posexplode、collect_set、collect_list

普通的行转列

--普通的行转列
select id,name from 
(select 1001 as id, 'a,b,c,d,e' as arr) a
lateral view explode(split(arr,',')) b as name
;

id	name
1001	a
1001	b
1001