Skip to main content

BITMAP_MAX

Description​

Computes and returns the maximum value in a Bitmap.

Syntax​

BITMAP_MAX(<bitmap>)

Parameters​

ParameterDescription
<bitmap>A Bitmap type column or expression

Return Value​

The maximum value in the Bitmap.
Returns NULL if the Bitmap is empty or NULL value.

Examples​

To compute the maximum value in an empty Bitmap:

select bitmap_max(bitmap_from_string('')) value;

The result will be:

+-------+
| value |
+-------+
| NULL |
+-------+

To compute the maximum value in a Bitmap with multiple elements:

select bitmap_max(bitmap_from_string('1,9999999999')) value;

The result will be:

+------------+
| value |
+------------+
| 9999999999 |
+------------+
select bitmap_max(bitmap_empty()) res1, bitmap_max(NULL) res2;

The result will be:

+------+------+
| res1 | res2 |
+------+------+
| NULL | NULL |
+------+------+