Computes and returns the maximum value in a Bitmap.
BITMAP_MAX(<bitmap>)
| Parameter | Description |
|---|---|
<bitmap> | A Bitmap type column or expression |
The maximum value in the Bitmap.
Returns NULL if the Bitmap is empty or NULL value.
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 | +------+------+