BITMAP_COUNT

​

Syntax

​

Scalar

bitmap_count(value)

​

Arguments

​

Returns

• Type: BIGINT
• Possible values: The total population count across every byte; zero for an empty bitmap.
• NULL behavior: Returns NULL for NULL input.

​

Properties

​

Examples

​

Typical behavior

SELECT bitmap_count(X'0F00FF') AS bits, bitmap_count(X'') AS empty_bitmap;

​

Count set bits rather than bytes

SELECT bitmap_count(X'0000') AS all_zero_bits, bitmap_count(X'FFFF') AS all_one_bits;