hive 分组后聚合 实现GROUP_CONCAT

select phone,CONCAT_WS(',',collect_set(column name)) from table
where ***group by phone

 

posted @ 2021-06-07 10:56  cup_leo  阅读(791)  评论(0编辑  收藏  举报