VeloDB Cloud
SQL Manual
SQL Functions
Aggregate Functions
GROUP_BITMAP_XOR

GROUP_BITMAP_XOR

description

Syntax

BITMAP GROUP_BITMAP_XOR(expr)

Perform an xor calculation on expr, and return a new bitmap.

example

mysql>  select page, bitmap_to_string(user_id) from pv_bitmap;
+------+-----------------------------+
| page | bitmap_to_string(`user_id`) |
+------+-----------------------------+
| m    | 4,7,8                       |
| m    | 1,3,6,15                    |
| m    | 4,7                         |
+------+-----------------------------+

mysql> select page, bitmap_to_string(group_bitmap_xor(user_id)) from pv_bitmap group by page;
+------+-----------------------------------------------+
| page | bitmap_to_string(group_bitmap_xor(`user_id`)) |
+------+-----------------------------------------------+
| m    | 1,3,6,8,15                                    |
+------+-----------------------------------------------+

keywords

GROUP_BITMAP_XOR,BITMAP