UNNEST_BITMAP

Expands a bitmap into a set of rows.

Analyze Syntax

func.unnest_bitmap(<bitmap>)

Analyze Examples

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

SQL Syntax

UNNEST_BITMAP(<bitmap>)

SQL Examples

SELECT * FROM TABLE(UNNEST_BITMAP(BITMAP_FROM_STRING('1,2,3')));

┌───────┐
 value 
├───────┤
     1 
     2 
     3 
└───────┘