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

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

Asked Jun 18, 2024 Modified Jun 19, 2024
Viewed 107
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
张彬华7698
answered Jun 20, 2024
Related Questions
odbc从doris4.0读取含有emoji表情符号时异常
1 answers
doris 4.x版本,请问 variant的子列单独设置的时候只支持text类型吗?
1 answers
Doris 索引问题
1 answers
Doris 4.0.2 MD5函数导致BE内存过高问题
1 answers
streamload使用jsonroot导入超大数组chunk问题
1 answers
服务器Doris数据库的数据盘为SSD,为何创建表的时候,提示我没有找到SSD,只能使用HDD呢
1 answers

Terms of service Privacy policy

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