hive sql 行转列 collect_set,collect_list 有序化展示
1、collect_set去除重复元素;collect_list不去除重复元素;需要进行group by select phone,collect_list(user_id) ,collect_set(user_id) from a group by phone 123456789 [1,3,2,1,2] [1,3,2]2、collect_list 展示子表排序后结果,col...