INTERSECT_COUNT
Returns the count of elements in the intersection of multiple bitmaps filtered by dimension.
Analyze Syntax
func.intersect_count(get_column(table, 'bm'), get_column(table, 'dim'), val1, val2)
Analyze Examples
func.intersect_count(get_column(table, 'bm'), get_column(table, 'tag'), 1, 2)
┌─────┐
│ 150 │
└─────┘
SQL Syntax
INTERSECT_COUNT(<bm>, <dim>, val1, val2)
SQL Examples
SELECT INTERSECT_COUNT(user_bm, tag, 1, 2) FROM segments;
┌─────┐
│ 150 │
└─────┘