BITMAP_OR_COUNT (Lakehouse v1)
Counts the number of bits set to 1 in the bitmap by performing a logical OR operation.
Analyze Syntax
Section titled “Analyze Syntax”func.bitmap_or_count( <bitmap> )Analyze Examples
Section titled “Analyze Examples”func.bitmap_or_count(func.to_bitmap('1, 3, 5'))
┌─────────────────────────────────────────────────┐│ func.bitmap_or_count(func.to_bitmap('1, 3, 5')) │├─────────────────────────────────────────────────┤│ 3 │└─────────────────────────────────────────────────┘SQL Syntax
Section titled “SQL Syntax”BITMAP_OR_COUNT( <bitmap> )SQL Examples
Section titled “SQL Examples”SELECT BITMAP_OR_COUNT(TO_BITMAP('1, 3, 5'));
┌───────────────────────────────────────┐│ bitmap_or_count(to_bitmap('1, 3, 5')) │├───────────────────────────────────────┤│ 3 │└───────────────────────────────────────┘