BITMAP_TO_ARRAY (Lakehouse v2)

Converts a bitmap to an array of integers.

Analyze Syntax

func.bitmap_to_array(<bitmap>)

Analyze Examples

func.bitmap_to_array(get_column(table, 'bm'))

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

SQL Syntax

BITMAP_TO_ARRAY(<bitmap>)

SQL Examples

SELECT BITMAP_TO_ARRAY(BITMAP_FROM_STRING('1,2,3'));

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