v.19.7New Features

Added Bitmap Related Functions Bitmaphasany and Bitmaphasall Analogous to Hasany and Hasall Functions for Arrays

Added bitmap related functions bitmapHasAny and bitmapHasAll analogous to hasAny and hasAll functions for arrays. #5279 (Sergi Vladykin)
Added new bitmap-related functions bitmapHasAny and bitmapHasAll that work similarly to the existing hasAny and hasAll functions for arrays.

Why it matters

These functions provide users with the ability to efficiently check for the presence of any or all specified elements within bitmap data structures, improving query expressiveness and performance when working with bitmap columns.

How to use it

Use the functions bitmapHasAny(bitmap, elements) and bitmapHasAll(bitmap, elements) in your SQL queries to test if the bitmap contains any or all of the specified elements respectively.