Function Bitmaprange(bitmap, Range_begin, Range_end) Which Returns New Set with Specified Range (not Include the Range_end)

Why it matters

This function allows users to efficiently extract a subset of elements from a bitmap based on a defined range. It is useful for scenarios where filtering or segmenting bitmap data by numerical ranges is required, improving query precision and performance.

How to use it

Use the function by passing an existing bitmap and the desired range boundaries as arguments, like so:

SELECT bitmapRange(bitmap_column, range_begin, range_end)
FROM table_name;

The result will include all elements from range_begin up to but not including range_end.