BITMAP_UNION_COUNT (Lakehouse v2)

Returns the count of distinct values in the union of a set of bitmaps.

Analyze Syntax

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

Analyze Examples

func.bitmap_union_count(get_column(table, 'user_bitmap'))

┌──────┐
│ 5000 │
└──────┘

SQL Syntax

BITMAP_UNION_COUNT(<bm>)

SQL Examples

SELECT BITMAP_UNION_COUNT(user_bitmap) FROM daily_visits;

┌──────┐
│ 5000 │
└──────┘