1建表语句
create table a(
id String,
price String);
数据表的记录如下:
5112 960024
5112 960025
5112 960026
5112 960027
5112 960028
5113 960043
5113 960044
5113 960045
5113 960046
对id进行合并:
select id, concat_ws(‘_’,collect_set(price)) as cs from a group by id
执行结果:
OK
5112 960024_960025_960026_960027_960028
5113 960043_960044_960045_960046
Time taken: 3.116 seconds
这里的collect_set的作用是对promotion_id去重,值得注意的是,必须保证promotion_id的类型是string类型