uniqTheta 函数

uniqTheta 函数适用于两个 uniqThetaSketch 对象，用于执行集合运算计算，例如 ∪ / ∩ / ×（并集/交集/非），它返回一个新的包含结果的 uniqThetaSketch 对象。

UniqThetaSketch 对象通过聚合函数 uniqTheta 和 -State 构建。

UniqThetaSketch 是近似值集合的数据结构存储。有关 RoaringBitmap 的更多信息，请参阅：Theta Sketch Framework。

uniqThetaUnion

两个 uniqThetaSketch 对象执行并集计算（集合运算 ∪），结果是一个新的 uniqThetaSketch。

uniqThetaUnion(uniqThetaSketch,uniqThetaSketch)

参数

• uniqThetaSketch – uniqThetaSketch 对象。

示例

select finalizeAggregation(uniqThetaUnion(a, b)) as a_union_b, finalizeAggregation(a) as a_cardinality, finalizeAggregation(b) as b_cardinality
from
(select arrayReduce('uniqThetaState',[1,2]) as a, arrayReduce('uniqThetaState',[2,3,4]) as b );

┌─a_union_b─┬─a_cardinality─┬─b_cardinality─┐
│         4 │             2 │             3 │
└───────────┴───────────────┴───────────────┘

uniqThetaIntersect

两个 uniqThetaSketch 对象执行交集计算（集合运算 ∩），结果是一个新的 uniqThetaSketch。

uniqThetaIntersect(uniqThetaSketch,uniqThetaSketch)

参数

• uniqThetaSketch – uniqThetaSketch 对象。

示例

select finalizeAggregation(uniqThetaIntersect(a, b)) as a_intersect_b, finalizeAggregation(a) as a_cardinality, finalizeAggregation(b) as b_cardinality
from
(select arrayReduce('uniqThetaState',[1,2]) as a, arrayReduce('uniqThetaState',[2,3,4]) as b );

┌─a_intersect_b─┬─a_cardinality─┬─b_cardinality─┐
│             1 │             2 │             3 │
└───────────────┴───────────────┴───────────────┘

uniqThetaNot

两个 uniqThetaSketch 对象执行 a_not_b 计算（集合运算 ×），结果是一个新的 uniqThetaSketch。

uniqThetaNot(uniqThetaSketch,uniqThetaSketch)

参数

• uniqThetaSketch – uniqThetaSketch 对象。

示例

select finalizeAggregation(uniqThetaNot(a, b)) as a_not_b, finalizeAggregation(a) as a_cardinality, finalizeAggregation(b) as b_cardinality
from
(select arrayReduce('uniqThetaState',[2,3,4]) as a, arrayReduce('uniqThetaState',[1,2]) as b );

┌─a_not_b─┬─a_cardinality─┬─b_cardinality─┐
│       2 │             3 │             2 │
└─────────┴───────────────┴───────────────┘

另请参阅

• uniqThetaSketch