数据仓库服务 GAUSSDB(DWS)-Roaring Bitmap聚合函数:rb_or_agg(roaringbitmap)

时间:2023-12-15 11:45:23

rb_or_agg(roaringbitmap)

描述:将分组内的roaringbitmap按照并的逻辑组合成一个roaringbitmap。

示例:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
SELECT a, rb_to_array(rb_or_agg(b)) FROM r1 GROUP BY a ORDER BY a;
 a  | rb_to_array
----+-------------
 1  | {1}
 2  | {3,5}
 3  | {5,9}
 4  | {7,13}
 5  | {9,17}
 6  | {1,11}
 7  | {5,13}
 8  | {9,15}
 9  | {13,17}
 10 | {17,19}
(10 rows)
support.huaweicloud.com/sqlreference-dws/dws_06_0324.html