Deduplicates rows united by multiple aliases.
- Expression: DISTINCT
alias1
,alias2
, ...
Comman Usage
Example: Direct deduplicate
uncollect [1,2,1,2] as a
uncollect [3,4,5,4] as b
return distinct a, b
1
2
1
3
4
5
Example: Multiply and deduplicate
uncollect [1,2,1,2] as a
uncollect [3,4,5,4] as b
with distinct a, b
return a, b
1
1
1
2
2
2
3
4
5
3
4
5