Categories:

Aggregate Functions (Counting Distinct Values)

BITMAP_CONSTRUCT_AGG

Returns a bitmap with bits set for each distinct value in a group.

See also:

Computing the Number of Distinct Values for Hierarchical Aggregations

Syntax

BITMAP_CONSTRUCT_AGG( <relative_position> )

Arguments

<relative_position>

The relative position of a bit for a value (returned by the BITMAP_BIT_POSITION function).

Returns

The function returns a BINARY value that is a bitmap with bits set for each distinct value in a group.