liu391447823 commented on issue #6875:
URL:
https://github.com/apache/incubator-doris/issues/6875#issuecomment-946744991
2.subBitmap
Returns the bitmap elements, starting from the offset position. The number
of returned elements is limited by the cardinality_limit parameter. Analog of
the substring) string function, but for bitmap.
Syntax
`subBitmap(bitmap, offset, cardinality_limit)`
Arguments
- bitmap – The bitmap. Type: Bitmap object
- offset – The position of the first element of the subset.
- cardinality_limit – The maximum number of elements in the subset.
Example
Query:
`SELECT
bitmapToArray(subBitmap(bitmapBuild([0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,100,200,500]),
toUInt32(10), toUInt32(10))) AS res;`
Result:
┌─res─────────────────────────────┐
│ [10,11,12,13,14,15,16,17,18,19] │
└─────────────────────────────────┘
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
