美文网首页
双列explode实现排列组合

双列explode实现排列组合

作者: 那只媛 | 来源:发表于2021-08-04 21:08 被阅读0次

select
userid,
author,
author1
from
(
select
123 as userid,
"1,2" as authorlist,
"1,2" as authorlist1
union all
select
234 as userid,
"3,4" as authorlist,
"3,4" as authorlist1
) details
lateral view explode(split(authorlist, ',')) t as author
lateral view explode(split(authorlist1, ',')) t1 as author1

image.png

相关文章

网友评论

      本文标题:双列explode实现排列组合

      本文链接:https://www.haomeiwen.com/subject/ndcpvltx.html