BITMAP_AND (Lakehouse v2)
返回两个位图的交集。
Analyze 语法
Section titled “Analyze 语法”func.bitmap_and(<bm1>, <bm2>)Analyze 示例
Section titled “Analyze 示例”func.bitmap_and(get_column(table, 'bm1'), get_column(table, 'bm2'))
┌──────────┐│ (bitmap) │└──────────┘SQL 语法
Section titled “SQL 语法”BITMAP_AND(<bm1>, <bm2>)SQL 示例
Section titled “SQL 示例”SELECT BITMAP_TO_STRING(BITMAP_AND(TO_BITMAP(1), TO_BITMAP(1)));
┌───┐│ 1 │└───┘