persto array_join(array_agg(),',')

-- mysql group_concat
select 
  a,  group_concat(b separator ',')
from table
group by a
;
-- presto
select 
  a,
  array_join(array_agg(b), ',')
from table
group by a
;
原文地址:https://www.cnblogs.com/linbo3168/p/14276634.html