BITMAP_CONSTRUCT_AGG | Snowflake Documentation (original) (raw)

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

Arguments¶

_relativeposition_

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.