Categories:: Aggregate functions (Counting Distinct Values)

BITMAP_BUCKET_NUMBER¶

Given a numeric value, returns an identifier (“bucket number”) for the bitmap containing the bit that represents the value..

See also:: Using Bitmaps to Compute Distinct Values for Hierarchical Aggregations

Syntax¶

BITMAP_BUCKET_NUMBER( <numeric_expr> )

Copy

Arguments¶

numeric_expr: This expression must evaluate to a data type that can be cast to NUMBER.

Returns¶

The function returns a number that identifies the bitmap containing the bit that represents the value.

Examples¶

See Using Bitmaps to Compute Distinct Values for Hierarchical Aggregations.