v.19.4New Features

Added Bitmap Functions with Roaring Bitmaps

Added bitmap functions with Roaring Bitmaps. #4207 (Andy Yang) #4568 (Vitaly Baranov)
Introduced bitmap functions using Roaring Bitmaps for efficient set operations and storage within ClickHouse.

Why it matters

The feature provides users with optimized bitmap functionality that improves performance for operations involving sets of integers, such as fast membership queries, unions, intersections, and counts. Roaring Bitmaps enable compact storage and efficient processing, enhancing analytical query capabilities on large datasets.

How to use it

Users can utilize the new bitmap functions by applying the provided SQL functions that operate on Roaring Bitmaps in their queries. These functions support creating, manipulating, and querying bitmap data types, seamlessly integrating into existing SQL workflows.