orthogonal_bitmap_union_count

description

Syntax

BITMAP ORTHOGONAL_BITMAP_UNION_COUNT(bitmap_column, column_to_filter, filter_values) Figure out the bitmap union count function, syntax with the original bitmap_union_count, but the implementation is different.

example

  1. mysql> select orthogonal_bitmap_union_count(members) from tag_map where  tag_group in ( 1150000, 1150001, 390006);
  2. +------------------------------------------+
  3. | orthogonal_bitmap_union_count(`members`) |
  4. +------------------------------------------+
  5. |                                286957811 |
  6. +------------------------------------------+
  7. 1 row in set (2.645 sec)

keyword

  1. ORTHOGONAL_BITMAP_UNION_COUNT,BITMAP