Help Center> GaussDB(DWS)> 8.2.0> Data Types> RoaringBitmap
Updated on 2023-02-08 GMT+08:00
View PDF

RoaringBitmap

In GaussDB(DWS) 8.1.3 and later, you can use the RoaringBitmap data type to store bitmap datasets.

The RoaringBitmap data type supports row-store and column-store tables.

Examples:

Create a table that supports the RoaringBitmap data type.

1
2
3
4
5
6
7
8
 
create table r_row ( a int ,b text, c roaringbitmap);
NOTICE:  The 'DISTRIBUTE BY' clause is not specified. Using round-robin as the distribution mode by default.
HINT:  Please use 'DISTRIBUTE BY' clause to specify suitable data distribution column.
CREATE TABLE
create table r_col ( a int ,b text, c roaringbitmap) with (orientation=column);
NOTICE:  The 'DISTRIBUTE BY' clause is not specified. Using round-robin as the distribution mode by default.
HINT:  Please use 'DISTRIBUTE BY' clause to specify suitable data distribution column.
CREATE TABLE
Parent topic: Data Types