presto支持group_concat

一、背景

1、实现分组后字段字符拼接，类似MYSQL的group_cocat函数

二、调研

1、官网地址：

Presto Documentation — Presto 0.284 Documentation

2、数据操作函数

Array Functions and Operators — Presto 0.285.1 Documentation

array_agg 将多个分组后字段组合为函数

select
  order_number,
  array_agg(refund_reason)
from
  test.table
where
  dt = '20240222' GROUP BY order_number  limit 10

array_join 数组分隔转字符串
array_join(array_agg(refund_reason),',') 就可以实现目标需求

三、实现

select
  order_number,
  array_join(array_agg(refund_reason),',')
from
  test.table
where
  dt = '20240222' GROUP BY order_number  limit 10