一、背景
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