BITMAP_AGG

Aggregates integer values into a bitmap.

Analyze Syntax

func.bitmap_agg(get_column(table, 'id'))

Analyze Examples

func.bitmap_agg(get_column(table, 'user_id'))

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

SQL Syntax

BITMAP_AGG(<id>)

SQL Examples

SELECT BITMAP_COUNT(BITMAP_AGG(user_id)) FROM visits;

┌─────┐
 500 
└─────┘