BITMAP_BUCKET_NUMBER¶
See: Understanding How Bitmaps Identify Distinct Values.
Syntax¶
BITMAP_BUCKET_NUMBER( <expr> )
Parameters¶
exprA numeric expression
Returns¶
Given a numeric input, returns a “bucket number” that finds the bitmap (fixed length = 10000) that has the input value. If the input in range [0, 9999], output = 0; if the input in range [10000, 19999], output = 1; if the input is negative, the output is negative as well – if input in range [-10000, 0), output = -1, etc.
Example¶
SELECT input, BITMAP_BUCKET_NUMBER(input) FROM T
|
|
|---|---|
|
|
|
|
|
|
|
|
|
|