orthogonal_bitmap_union_count
Description
Syntax:
BITMAP ORTHOGONAL_BITMAP_UNION_COUNT(bitmap_column, column_to_filter, filter_values)
This function calculates the size of union of bitmaps. The first argument is the target bitmap column.
Example
mysql> select orthogonal_bitmap_union_count(members) from tag_map where tag_group in ( 1150000, 1150001, 390006);
+------------------------------------------+
| orthogonal_bitmap_union_count(`members`) |
+------------------------------------------+
| 286957811 |
+------------------------------------------+
1 row in set (2.645 sec)Keywords
ORTHOGONAL_BITMAP_UNION_COUNT,BITMAP