Categories:

Aggregate Functions (Counting Distinct Values)

BITMAP_COUNT¶

Given a bitmap that represents the set of distinct values for a column, returns the number of distinct value.

See also:

Using Bitmaps to Compute Distinct Values for Hierarchical Aggregations

Syntax¶

BITMAP_COUNT( <bitmap> )
Copy

Arguments¶

bitmap

This expression must evaluate to a bitmap returned by the BITMAP_CONSTRUCT_AGG or BITMAP_OR_AGG functions.

Returns¶

The function returns the number of distinct values in a column, as represented by the bits set in the input bitmap.

Examples¶

See Using Bitmaps to Compute Distinct Values for Hierarchical Aggregations.