hql-行列转换

行转列
hive -e ”
select id,word
from (
select ‘123’ as id,’java,c,php’ words from file_cto_user limit 1
) ta
lateral view explode(split(words,’,’)) uu as word
“

列转行
hive -e ”
select ubi.id,ubi.name, concat_ws(‘,’, collect_set(ua.address)) as address
from user_basic_info ubi
join user_address ua
on ubi.name=ua.name group by ubi.name;
“