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