mysql:
select ORDR_ID,USER_ID, group_concat(PM_ID) from 表名 group by ORDR_ID limit 10
hive :
select ordr_id ,user_id, concat_ws(',',collect_set(pm_id))as pm_ids from 表名 group by ordr_id,user_id limit 100000
mysql:
select ORDR_ID,USER_ID, group_concat(PM_ID) from 表名 group by ORDR_ID limit 10
hive :
select ordr_id ,user_id, concat_ws(',',collect_set(pm_id))as pm_ids from 表名 group by ordr_id,user_id limit 100000