v.19.10New Feature

Bitmapcontains Implementation

bitmapContains implementation. It's 2x faster than bitmapHasAny if the second bitmap contains one element. #5535 (Zhichang Yu)
bitmapContains function implementation for ClickHouse, offering optimized bitmap containment checks.

Why it matters

To provide a faster alternative to bitmapHasAny when checking if the second bitmap contains exactly one element, improving query performance by up to 2x in such cases.

How to use it

Use the new function <code>bitmapContains(bitmap1, bitmap2)</code> in your queries where you need to check if the first bitmap contains the elements of the second bitmap, especially when the second bitmap has one element.