BITMAP_COUNT Function

bitmap_count(bitmap)

Description

The BITMAP_COUNT function returns the number of elements in a bitmap. It is equivalent to BITMAP_CARDINALITY.

Parameters

• bitmap: BITMAP type.

Return Type

• Returns BIGINT type.

Notes

• This function is an alias for BITMAP_CARDINALITY, and both provide identical functionality.

Examples

1. Count elements in a bitmap

SELECT bitmap_count(bitmap_build(array(1, 2, 3))); +----------------------------------------------+ | bitmap_count(bitmap_build(array(1, 2, 3))) | +----------------------------------------------+ | 3 | +----------------------------------------------+

2. Count elements in a larger bitmap

SELECT bitmap_count(bitmap_build(array(1, 2, 3, 4, 5))); +----------------------------------------------------+ | bitmap_count(bitmap_build(array(1, 2, 3, 4, 5))) | +----------------------------------------------------+ | 5 | +----------------------------------------------------+