- 行转列
select max(ubi.key), concat_ws(',', collect_set(ua.number)) as number from user_basic_info ubi
example
key number
a 1
a 2
b 1
convert to
a 1,2
b 1
select max(ubi.key), concat_ws(',', collect_set(ua.number)) as number from user_basic_info ubi
example
key number
a 1
a 2
b 1
convert to
a 1,2
b 1
本文标题：HIVE系列
本文链接：https://www.haomeiwen.com/subject/iawpattx.html
网友评论