BITMAP_TO_STRING Function

bitmap_to_string(bitmap)

Description

The BITMAP_TO_STRING function converts a bitmap to a comma-separated string.

Parameters

• bitmap: BITMAP type.

Return Type

• Returns STRING type, representing the bitmap elements as a comma-separated string.

Examples

1. Convert a bitmap to a string

SELECT bitmap_to_string(bitmap_build(array(1, 2)));
+-----------------------------------------------+
| bitmap_to_string(bitmap_build(array(1, 2)))   |
+-----------------------------------------------+
| 1,2                                           |
+-----------------------------------------------+

2. Convert a bitmap with multiple elements

SELECT bitmap_to_string(bitmap_build(array(1, 3, 5)));
+--------------------------------------------------+
| bitmap_to_string(bitmap_build(array(1, 3, 5)))   |
+--------------------------------------------------+
| 1,3,5                                            |
+--------------------------------------------------+