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

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.

Examples¶

See Using Bitmaps to Compute Distinct Values for Hierarchical Aggregations.