BITMAP_HAS_ANY

Function Description

The BITMAP_HAS_ANY function is used to check if the left bitmap contains any of the elements in the right bitmap. In other words, this function is used to determine if there is an intersection between the two bitmaps.

Syntax Format

bitmap_has_any(left, right)

Parameter Description

• left: The first parameter of type bitmap.
• right: The second parameter of type bitmap.

Return Result

Returns a boolean value. If the left bitmap contains any element from the right bitmap, it returns true; otherwise, it returns false.

Usage Example

1. Check if two bitmaps intersect:

SELECT bitmap_has_any(bitmap_build(array(1, 2, 3)), bitmap_build(array(2, 3)));

Results:

 true

2. Check if a bitmap contains all elements of another bitmap:

SELECT bitmap_has_any(bitmap_build(array(1, 2, 3, 4)), bitmap_build(array(3, 4)));

Results:

 false

3. Determine whether one bitmap is completely contained within another bitmap:

SELECT bitmap_has_any(bitmap_build(array(1, 2, 3)), bitmap_build(array(1, 2, 3, 4)));

Results:

 true

Notes

• Ensure that the parameter types passed in are correct, otherwise it may cause the function to fail.
• The BITMAP_HAS_ANY function is mainly used for comparing bitmap type data and may not be applicable to other data types.