orthogonal_bitmap_intersect_count
Description
Syntax:
BITMAP ORTHOGONAL_BITMAP_INTERSECT_COUNT(bitmap_column, column_to_filter, filter_values)
This function calculates the size of intersection of bitmaps. The first argument is the bitmap column, the second is the dimension column used for filtering, and the third is a variable-length argument, which specifies filter values.
Example
mysql> select orthogonal_bitmap_intersect_count(members, tag_group, 1150000, 1150001, 390006) from tag_map where tag_group in ( 1150000, 1150001, 390006);
+-------------------------------------------------------------------------------------+
| orthogonal_bitmap_intersect_count(`members`, `tag_group`, 1150000, 1150001, 390006) |
+-------------------------------------------------------------------------------------+
| 0 |
+-------------------------------------------------------------------------------------+
1 row in set (3.382 sec)Keywords
ORTHOGONAL_BITMAP_INTERSECT_COUNT,BITMAP