表达式

DISTINCT alias1, alias2, ...

• 含义：将多个别名代表的数据行按行联合去重

示例

一般用法

本例对异源别名a和b直接去重：

uncollect [1,2,1,2] as a
uncollect [3,4,5,4] as b
return distinct a, b

1
2
1

3
4
5

本例对异源别名a和b进行笛卡尔积组合后去重：

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