函数concat_ws:
select id, concat_ws('_',collect_set(col1)) as concatcol1 from table group by id
函数 groupconcat:
select id,group_concat(distinct(col1),'_') as concatcol1 from table group by id
函数concat_ws:
select id, concat_ws('_',collect_set(col1)) as concatcol1 from table group by id
函数 groupconcat:
select id,group_concat(distinct(col1),'_') as concatcol1 from table group by id