BITMAP_INTERSECT (Lakehouse v2)
返回一组位图的交集(聚合函数)。
Analyze 语法
Section titled “Analyze 语法”func.bitmap_intersect(get_column(table, 'bm'))Analyze 示例
Section titled “Analyze 示例”func.bitmap_intersect(get_column(table, 'user_bitmap'))
┌──────────┐│ (bitmap) │└──────────┘SQL 语法
Section titled “SQL 语法”BITMAP_INTERSECT(<bm>)SQL 示例
Section titled “SQL 示例”SELECT BITMAP_COUNT(BITMAP_INTERSECT(user_bitmap)) FROM segments;
┌─────┐│ 100 │└─────┘