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

```sql
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

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

```text
+------+
| bs   |
+------+
| 0,1  |
+------+
```


```sql
SELECT bitmap_to_string(bitmap_from_array(NULL)) AS bs;
```

```text
+------+
| bs   |
+------+
| NULL |
+------+
```

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

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