neuyilan opened a new issue, #4999: URL: https://github.com/apache/paimon/issues/4999
### Search before asking - [x] I searched in the [issues](https://github.com/apache/paimon/issues) and found nothing similar. ### Paimon version master 1.1 0.9 0.8 ### Compute Engine none ### Minimal reproduce step 1. create table with collect agg and distinct field ``` CREATE TABLE test_collect( id INT PRIMARY KEY NOT ENFORCED, f0 ARRAY<STRING> ) WITH ( 'merge-engine' = 'aggregation', 'fields.f0.aggregate-function' = 'collect', 'fields.f0.distinct' = 'true' ) ``` 2. insert values `INSERT INTO test_collect VALUES (1, ARRAY['A', 'B', 'A', 'A']);` 3. query the results. `SELECT * FROM test_collect` the result is as follows, it does not meet expectations ` 1, [A, B, A, A] ` ### What doesn't meet your expectations? Return deduplicate list value. for above example, the result shoud be: ` 1, [A, B] ` ### Anything else? no ### Are you willing to submit a PR? - [ ] I'm willing to submit a PR! -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
