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> )

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.

Back to top