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