可以将含有多个别名按行联合并去重。
- 表达式:DISTINCT
alias1
,alias2
, ...
一般用法
示例:异源别名直接去重
uncollect [1,2,1,2] as a
uncollect [3,4,5,4] as b
return distinct a, b
1
2
1
3
4
5
示例:异源别名笛卡尔乘积后去重
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