BITMAP_COUNT
Descriptionβ
Count the number of elements in the input BITMAP
Syntaxβ
BITMAP_COUNT(<bitmap>)
Parametersβ
Parameter | Description |
---|---|
<bitmap> | a BITMAP |
Return Valueβ
Returns an integer
Examplesβ
select bitmap_count(to_bitmap(1)) cnt;
+------+
| cnt |
+------+
| 1 |
+------+
select bitmap_count(bitmap_empty()) cnt;
+------+
| cnt |
+------+
| 0 |
+------+