docs/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-empty.md

{ “title”: “BITMAP_EMPTY”, “language”: “en”, “description”: “Construct an empty BITMAP. Mainly used to fill default values during insert or stream load. For example:” }

Description

Construct an empty BITMAP. Mainly used to fill default values during insert or stream load. For example:

cat data | curl --location-trusted -u user:passwd -T - -H "columns: dt,page,v1,v2=bitmap_empty()"   http://127.0.0.1:8040/api/test_database/test_table/_stream_load

Syntax

BITMAP_EMPTY()

Return Value

Returns an empty array with no elements

Examples

select bitmap_to_string(bitmap_empty());

+----------------------------------+
| bitmap_to_string(bitmap_empty()) |
+----------------------------------+
|                                  |
+----------------------------------+

select bitmap_count(bitmap_empty());

+------------------------------+
| bitmap_count(bitmap_empty()) |
+------------------------------+
|                            0 |
+------------------------------+