BITMAP_MAX

Description

Computes and returns the maximum value in a Bitmap.

Syntax

BITMAP_MAX(<bitmap>)

Parameters

Parameter	Description
<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 |
+------+------+