v.19.7New Features
Added Bitmap Related Functions Bitmaphasany and Bitmaphasall Analogous to Hasany and Hasall Functions for Arrays
Added bitmap related functionsbitmapHasAnyandbitmapHasAllanalogous tohasAnyandhasAllfunctions for arrays. #5279 (Sergi Vladykin)
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 functionsbitmapHasAny(bitmap, elements) and bitmapHasAll(bitmap, elements) in your SQL queries to test if the bitmap contains any or all of the specified elements respectively.