Skip to main content

Bitmap Functions

Introduced: v1.1.50
FunctionDescriptionExampleResult
bitmap_count(bitmap)Counts the number of bits set to 1 in the bitmap.bitmap_count(build_bitmap([1,4,5]))3
bitmap_contains(bitmap, value)Checks if the bitmap contains a specific value.bitmap_contains(build_bitmap([1,4,5]), 1)1
bitmap_has_all(bitmap1, bitmap2)Checks if the first bitmap contains all the bits in the second bitmap.bitmap_has_all(build_bitmap([1,4,5]), build_bitmap([1,2]))0
bitmap_has_any(bitmap1, bitmap2)Checks if the first bitmap has any bit matching the bits in the second bitmap.bitmap_has_any(build_bitmap([1,4,5]), build_bitmap([1,2]))1
bitmap_max(bitmap)Gets the maximum value in the bitmap.bitmap_max(build_bitmap([1,4,5]))5
bitmap_min(bitmap)Gets the minimum value in the bitmap.bitmap_min(build_bitmap([1,4,5]))1
bitmap_or(bitmap1, bitmap2)Performs a bitwise OR operation on the two bitmaps.bitmap_or(build_bitmap([1,4,5]), build_bitmap([6,7]))::String1,4,5,6,7
bitmap_and(bitmap1, bitmap2)Performs a bitwise AND operation on the two bitmaps.bitmap_and(build_bitmap([1,4,5]), build_bitmap([4,5]))::String4,5
bitmap_xor(bitmap1, bitmap2)Performs a bitwise XOR (exclusive OR) operation on the two bitmaps.bitmap_xor(build_bitmap([1,4,5]), build_bitmap([5,6,7]))::String1,4,6,7
bitmap_not(bitmap1, bitmap2)Performs a bitwise NOT operation on the bitmap with respect to another bitmap.bitmap_not(build_bitmap([2,3]), build_bitmap([2,3,5]))::String(empty)
bitmap_and_not(bitmap1, bitmap2)Performs a bitwise AND-NOT operation on the two bitmaps.bitmap_and_not(build_bitmap([2,3]), build_bitmap([2,3,5]))::String(empty)
bitmap_subset_limit(bitmap, start, limit)Generates a sub-bitmap of the source bitmap, beginning with a range from the start value, with a size limit.bitmap_subset_limit(build_bitmap([1,4,5]), 2, 2)::String4,5
bitmap_subset_in_range(bitmap, start, end)Generates a sub-bitmap of the source bitmap within a specified range.bitmap_subset_in_range(build_bitmap([5,7,9]), 6, 9)::String7
sub_bitmap(bitmap, start, size)Generates a sub-bitmap of the source bitmap, beginning from the start index, with a specified size.sub_bitmap(build_bitmap([1, 2, 3, 4, 5]), 1, 3)::String2,3,4
bitmap_and_count(bitmap)Counts the number of bits set to 1 in the bitmap by performing a logical AND operation.bitmap_and_count(to_bitmap('1, 3, 5'))3
bitmap_or_count(bitmap)Counts the number of bits set to 1 in the bitmap by performing a logical OR operation.bitmap_or_count(to_bitmap('1, 3, 5'))3
bitmap_xor_count(bitmap)Counts the number of bits set to 1 in the bitmap by performing a logical XOR (exclusive OR) operation.bitmap_xor_count(to_bitmap('1, 3, 5'))3