BITMAP_BIT_POSITION¶
See: Understanding How Bitmaps Identify Distinct Values.
Syntax¶
BITMAP_BIT_POSITION( <expr> )
Parameters¶
exprA numeric expression
Returns¶
Returns the zero-based position of the numeric input in a bitmap (fixed length = 10000).
Example¶
SELECT input, BITMAP_BIT_POSITION(input) FROM T
|
|
|---|---|
|
|
|
|
|
|
|
|
|
|