ARRAY_TO_BITMAP

Learn how to use the ARRAY_TO_BITMAP array function in PlaidCloud Lakehouse. Converts an array of integers to a bitmap - see syntax, examples, and output.

Converts an array of integers to a bitmap.

Analyze Syntax

func.array_to_bitmap([1, 2, 3])

Analyze Examples

func.array_to_bitmap([1, 2, 3])

┌──────────┐
│ (bitmap) │
└──────────┘

SQL Syntax

ARRAY_TO_BITMAP([1, 2, 3])

SQL Examples

SELECT BITMAP_TO_STRING(ARRAY_TO_BITMAP([1, 2, 3]));

┌───────┐
│ 1,2,3 │
└───────┘