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.

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