orthogonal_bitmap_intersect_count

description

Syntax

BITMAP ORTHOGONAL_BITMAP_INTERSECT_COUNT(bitmap_column, column_to_filter, filter_values) 求bitmap交集大小的函数, 第一个参数是Bitmap列，第二个参数是用来过滤的维度列，第三个参数是变长参数，含义是过滤维度列的不同取值

example

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

keyword

  1. ORTHOGONAL_BITMAP_INTERSECT_COUNT,BITMAP