BITMAP_TO_ARRAY
Descriptionβ
Converts a Bitmap into an Array.
Syntaxβ
BITMAP_TO_ARRAY(<bitmap>)
Parametersβ
| Parameter | Description |
|---|---|
<bitmap> | A Bitmap type column or expression |
Return Valueβ
An array containing all the bit positions in the Bitmap.
Returns NULL if the Bitmap is NULL.
Examplesβ
To convert a NULL Bitmap to an array:
select bitmap_to_array(null);
The result will be:
+------------------------+
| bitmap_to_array(NULL) |
+------------------------+
| NULL |
+------------------------+
To convert an empty Bitmap to an array:
select bitmap_to_array(bitmap_empty());
The result will be:
+---------------------------------+
| bitmap_to_array(bitmap_empty()) |
+---------------------------------+
| [] |
+---------------------------------+
To convert a Bitmap with a single element to an array:
select bitmap_to_array(to_bitmap(1));
The result will be:
+-------------------------------+
| bitmap_to_array(to_bitmap(1)) |
+-------------------------------+
| [1] |
+-------------------------------+
To convert a Bitmap with multiple elements to an array:
select bitmap_to_array(bitmap_from_string('1,2,3,4,5'));
The result will be:
+--------------------------------------------------+
| bitmap_to_array(bitmap_from_string('1,2,3,4,5')) |
+--------------------------------------------------+
| [1, 2, 3, 4, 5] |
+--------------------------------------------------+
