concat_ws()和lateral view explode()
concat_ws()和lateral view explode()
数据:
t1表
uid tags
1 1,2,3
2 2,3
3 1,2
编写sql实现如下结果:
uid tag
1 1
1 2
1 3
2 2
2 3
3 1
3 2
-- 创建表
use bg401;
CREATE TABLE IF NOT EXISTS exptest(
uid int,
tags array<string>
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY
原创
2020-09-21 21:25:07 ·
206 阅读 ·
0 评论