1、lateral view + explode 使用
select explode(split('0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20',',')); --结果是一列
lateral view能把UDTF结果组合,产生一个支持别名表的虚拟表。
with t as (
select 1 as id,'lisi' as name
union all
select 2 as id,'wangwu' as name
)
select t.id
,t.name
,ex.basic_salary
from t lateral view explode(split('4500,5000',',')