MySQL
select
columnA,
group_concat(columnB separator ',')
from table
group by columnA
Hive
select
columnA,
concat_ws('_', collect_set(columnB))
from table
group by columnA
Presto
select
columnA,
array_join(array_agg(columnB), ',')
from table
group by columnA
参考 Presto
官网:
6.14. Aggregate Functions
6.16. Array Functions and Operators