1、行列转换
行转列:collect_set/collect_list
列转行：
select t1.*, t2.col3_new
from
(
select ‘a‘ as col1, ‘b‘ as col2, ‘1,2,3‘ as col3
union all
select ‘c‘ as col1, ‘d‘ as col2, ‘4,5,6‘ as col3
)t1
lateral view explode(split(col3,‘,‘))t2 as col3_new; -- 主要是最后一行的写法
原文：https://www.cnblogs.com/gouhaiping/p/14620739.html