Repository navigation
[Feature] group_uniq_array function #13982
Description
Search before asking
- I had searched in the issues and found no similar issues.
Description
syntax: groupUniqArray(x) or groupUniqArray(max_size)(x)
function: Creates an array from different argument values.
SELECT *
FROM arrays_test
┌─s───────┬─arr─────┐
│ alex │ [1,2] │
│ hello │ [1,2] │
│ World │ [3,4,5] │
│ Goodbye │ [] │
└─────────┴─────────┘
SELECT groupUniqArray(arr) from arrays_test
┌─groupUniqArray(arr)─┐
│ [[],[1,2],[3,4,5]] │
└─────────────────────┘
Use case
No response
Related issues
No response
Are you willing to submit PR?
- Yes I am willing to submit a PR!
Code of Conduct
- I agree to follow this project's Code of Conduct
Activity
Hastyshell commentedon Dec 19, 2022
Apply for a try.
Hastyshell commentedon Dec 22, 2022
When doing this job,I found that this function is quite similar with
collect_set, except for the 'max_size ' limit.The sibling functiongroup_arrayseems also in this situation.Shall we upgrade thecollect_setandcollect_listto support the same semantics of the above two,or just simply create new functions asgroup_uniq_arrayandgroup_array?