to_bitmap

Description

Converts a BIGINT value into a BITMAP value. The input is an unsigned BIGINT value ranging from 0 to 18446744073709551615. The output is a BITMAP value containing this element. This function is mainly used for the load task to load integer fields into the bitmap field of the CelerData table.

Syntax

BITMAP TO_BITMAP(expr)

Examples

MySQL > select bitmap_count(to_bitmap(10));
+-----------------------------+
| bitmap_count(to_bitmap(10)) |
+-----------------------------+
|                           1 |
+-----------------------------+

keyword

TO_BITMAP,BITMAP