Categories:

Aggregate Functions (Counting Distinct Values)

BITMAP_BIT_COUNT

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

See also:

Computing the Number of Distinct Values for Hierarchical Aggregations

Syntax

BITMAP_BIT_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.