v.21.9New Feature
Added bitmapSubsetOffsetLimit Function for Bitmap Subsets
AddedbitmapSubsetOffsetLimit(bitmap, offset, cardinality_limit)function. It creates a subset of bitmap limit the results tocardinality_limitwith offset ofoffset. #27234 (DHBin).
Why it matters
This feature allows users to extract a subset from a bitmap, starting from a specified offset, and limiting the size of the subset to a defined cardinality. It is useful for efficient partial bitmap retrieval and processing, enabling better control over the data volume and performance optimization.How to use it
Use the function by passing a bitmap, anoffset value to skip initial elements, and a cardinality_limit to restrict the subset size. For example:SELECT bitmapSubsetOffsetLimit(your_bitmap_column, offset_value, cardinality_limit_value) FROM your_table;