数据仓库服务 GaussDB(DWS)-Roaring Bitmap聚合函数:rb_or_agg(roaringbitmap)
时间:2025-02-12 15:05:10
rb_or_agg(roaringbitmap)
描述:将分组内的roaringbitmap按照并的逻辑组合成一个roaringbitmap。
示例:
1 2 3 4 5 6 7 8 91011121314 |
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
推荐文章