BITMAP_BIT_POSITION | Snowflake Documentation (original) (raw)

Given a numeric value, returns the relative position for the bit that represents that value in a bitmap.

See also:

Using Bitmaps to Compute Distinct Values for Hierarchical Aggregations

Syntax¶

BITMAP_BIT_POSITION( )

Arguments¶

_numericexpr_

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

Returns¶

The function returns the zero-based position of the bit for that value in a bitmap.

Examples¶

See Using Bitmaps to Compute Distinct Values for Hierarchical Aggregations.