intersect_count

description

Syntax

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

example

1. MySQL [test_query_qa]> select dt,bitmap_to_string(user_id) from pv_bitmap where dt in (3,4);
2. +------+-----------------------------+
3. | dt   | bitmap_to_string(`user_id`) |
4. +------+-----------------------------+
5. |    4 | 1,2,3                       |
6. |    3 | 1,2,3,4,5                   |
7. +------+-----------------------------+
8. 2 rows in set (0.012 sec)

10. MySQL [test_query_qa]> select intersect_count(user_id,dt,3,4) from pv_bitmap;
11. +----------------------------------------+
12. | intersect_count(`user_id`, `dt`, 3, 4) |
13. +----------------------------------------+
14. |                                      3 |
15. +----------------------------------------+
16. 1 row in set (0.014 sec)

keywords

1. INTERSECT_COUNT,BITMAP