| --- |
| { |
| "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 |
| |
| ```sql |
| BITMAP_EMPTY() |
| ``` |
| |
| ## Return Value |
| |
| Returns an empty array with no elements |
| |
| ## Examples |
| |
| ```sql |
| select bitmap_to_string(bitmap_empty()); |
| ``` |
| |
| ```text |
| +----------------------------------+ |
| | bitmap_to_string(bitmap_empty()) | |
| +----------------------------------+ |
| | | |
| +----------------------------------+ |
| ``` |
| |
| ```sql |
| select bitmap_count(bitmap_empty()); |
| ``` |
| |
| ```text |
| +------------------------------+ |
| | bitmap_count(bitmap_empty()) | |
| +------------------------------+ |
| | 0 | |
| +------------------------------+ |
| ``` |