Categories:

Aggregate Functions (Counting Distinct Values)

BITMAP_CONSTRUCT_AGG

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

See also:

Using Bitmaps to Compute 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.

Back to top