-- hive
SELECt
t.xm, t.sfzh,concat_ws(',', collect_set(t.rylx)) rylx
FROM
table t
GROUP BY
t.xm, t.sfzh
-- Presto SELECt t.xm, t.sfzh, array_join(array_agg(distinct t.rylx), ',') rylx FROM table t GROUP BY t.xm, t.sfzh
-- hive
SELECt
t.xm, t.sfzh,concat_ws(',', collect_set(t.rylx)) rylx
FROM
table t
GROUP BY
t.xm, t.sfzh
-- Presto SELECt t.xm, t.sfzh, array_join(array_agg(distinct t.rylx), ',') rylx FROM table t GROUP BY t.xm, t.sfzh
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
