[Bug] group_concat don't support using distinct with order by together

[pengtao211]

Search before asking

• [X] I had searched in the issues and found no similar issues.

Version

2.0.1

What's Wrong?

1105 - errCode = 2, detailMessage = group_concat don't support using distinct with order by together: group_concat(DISTINCT time ORDER BY time ASC)

What You Expected?

I hope the group_concat support using distinct with order by together

How to Reproduce?

SELECT day, GROUP_CONCAT(distinct time ORDER BY time) FROM ( SELECT 'Monday' day, '15:00-21:00' time UNION ALL SELECT 'Monday' day, '09:00-13:00' time UNION ALL SELECT 'Monday' day, '09:00-13:00' time ) tab GROUP BY day

Anything Else?

No response

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[ixzc]

This is not supported. You can do it another way

[pengtao211]

This is not supported. You can do it another way

What is the other way？

[ixzc]

like this:

CREATE TABLE test_GROUP_CONCAT( value varchar(10) )ENGINE=OLAP DISTRIBUTED BY HASH(value)
PROPERTIES ( "replication_num" = "1" );

INSERT INTO test_GROUP_CONCAT (value) VALUES ('a'), ('b'), ('c'), ('c');

select GROUP_CONCAT( valueORDER BY value ASC) from ( select distinct value from test_GROUP_CONCAT ) a ;

[over-space]

group_concat can be converted to ARRAY_JOIN, ARRAY_SORT, COLLECT_SET/COLLECT_LIST combinations.

like this:

[pengtao211]

group_concat can be converted to ARRAY_JOIN, ARRAY_SORT, COLLECT_SET/COLLECT_LIST combinations.

like this:

thank