---- concat_ws(',','str1','str2','str3') --- 'str1,str2,str3'
---concat_ws 将字符串联起来用','隔开
列转行:
select col1,col2,concat_ws(',',collect_list(col3)) as col3 from table group by col1,col2
行转列:
select col1,col2,name from tableName lateral view explode(col3) col3 as name