hive中取某个id相关的所有字段

sql这块用的比较少，记录一下：

SELECT user_id, concat_ws(',',collect_set(string(pc))) ALL FROM table.work GROUP BY user_id LIMIT 10;