BITMAP_MIN

Description

Computes and returns the minimum value in a Bitmap.

Syntax

BITMAP_MIN(<bitmap>)

Parameters

Parameter	Description
<bitmap>	A Bitmap type column or expression

Return Value

The minimum value in the Bitmap.
Returns NULL if the Bitmap is empty.

Examples

To compute the minimum value in an empty Bitmap:

select bitmap_min(bitmap_from_string('')) value;

The result will be:

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

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

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

The result will be:

+-------+
| value |
+-------+
|     1 |
+-------+