hive 行转列

示例语句

select name,coment_split from (

select 'A' as name,'1,2,3,4' AS coment from dim.dual
union ALL
select 'B' as name,'4,5' AS coment from dim.dual
    ) a  lateral view explode(split(coment, ',')) a_split AS coment_split;