今天在做业务的时候遇到一个一行转多行,并且关联的问题。
记录一下
‘a,b,c,d’,‘1,2,3,4’
弄成
a 1
b 2
c 3
d 4
可以通过炸裂+排序辅助
SQL:
select
single_t1,
single_t2
from
(
select
row_number() over(PARTITION BY '1' ORDER BY '1' DESC) as j,
single_t1
from
(
select
'a,b,c,d' as t1,
'1,2,3,4' as t2
) a lateral view explode(split(t1, ',')) test_t1 as single_t1
) t1
left join (
select
row_number() over(PARTITION BY '1' ORDER BY '1' DESC) as j,
single_t2
from
(
select
'a,b,c,d' as t1,
'1,2,3,4' as t2
) a lateral view explode(split(t2, ',')) test_t2 as single_t2
) t2 on t1.j = t2.j;