Apache Doris 中文技术论坛
Questions Tags Users Badges

group_concat 什么时候可以支持Distinct 和 order by 一起用?

Asked Jun 18, 2024 Modified Jun 19, 2024
Viewed 60
query

ERROR 1105 (HY000): errCode = 2, detailMessage = group_concat don't support using distinct with order by together: group_concat(DISTINCT X.xxxx ORDER BY X.xxxx ASC, ',' ASC)

edited Jun 19, 2024
sg300003
asked Jun 18, 2024
1 Answers

如果需要同时实现去重和排序的功能,当前可能需要考虑其它替代方案或使用多个查询步骤来完成。

edited Jan 1, 1970
张彬华7693
answered Jun 20, 2024
Related Questions
doris sql查询慢,倒排索引查询NULL值问题
1 answers
Doris 做业务查询时,多个大子查询 使用 UNION ALL 联合后通过时间过滤一天数据还是会内存不足
1 answers
对于JSON_ARRAY JSON数组嵌套数据的处理,大家有什么好的处理办法吗?
EXPLAIN语句执行问题
1 answers
be各节点数据均衡
2 answers
Doris2.0.3版本ROUND函数四舍五入偶发性错误
1 answers

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2025 Apache Doris 中文技术论坛.