bitmap_and_not_count
bitmap_and_not_countβ
descriptionβ
Syntaxβ
BITMAP BITMAP_AND_NOT_COUNT(BITMAP lhs, BITMAP rhs)
Calculate the set after lhs minus intersection of two input bitmaps, return the new bitmap size.
exampleβ
mysql> select bitmap_and_not_count(bitmap_from_string('1,2,3'),bitmap_from_string('3,4,5')) cnt;
+------+
| cnt |
+------+
| 2 |
+------+
keywordsβ
BITMAP_AND_NOT_COUNT,BITMAP