docs/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-from-array.md

{ “title”: “BITMAP_FROM_ARRAY”, “language”: “en”, “description”: “Converts an array of TINYINT/SMALLINT/INT/BIGINT type to a BITMAP. When the input field is illegal, the result returns NULL.” }

Description

Converts an array of TINYINT/SMALLINT/INT/BIGINT type to a BITMAP. When the input field is illegal, the result returns NULL.

Syntax

BITMAP_FROM_ARRAY(<arr>)

Parameters

Parameter	Description
`<arr>`	integer array

Return Value

Returns a BITMAP

When the input field is invalid, the result is NULL

Examples

SELECT bitmap_to_string(bitmap_from_array(array(1, 0, 1, 1, 0, 1, 0))) AS bs;

+------+
| bs   |
+------+
| 0,1  |
+------+

SELECT bitmap_to_string(bitmap_from_array(NULL)) AS bs;

+------+
| bs   |
+------+
| NULL |
+------+

select bitmap_to_string(bitmap_from_array([1,2,3,-1]));

+-------------------------------------------------+
| bitmap_to_string(bitmap_from_array([1,2,3,-1])) |
+-------------------------------------------------+
| NULL                                            |
+-------------------------------------------------+