Help Center/ GaussDB(DWS)/ SQL Syntax Reference/ SQL Syntax Reference (9.1.0.x)/ Data Types/ RoaringBitmap
Updated on 2024-09-02 GMT+08:00
View PDF
Share

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.

Table 1 RoaringBitmap

Name

Storage Size

Description

Range

RoaringBitmap

32 bytes

Stores bitmap data sets.

-2,147,483,648~2,147,483,647

Example: Create a table with the RoaringBitmap data type.

1
2
 
CREATE TABLE r_row (a int ,b text, c roaringbitmap);
CREATE TABLE r_col (a int ,b text, c roaringbitmap) with (orientation=column);
Parent topic: Data Types