v.19.17New Feature

Add Bitmaptransform Function

Add bitmapTransform function. It transforms an array of values in a bitmap to another array of values, the result is a new bitmap #7598 (Zhichang Yu)
Introduces a new function bitmapTransform that transforms an array of values within a bitmap to another array of values, producing a new bitmap as the result.

Why it matters

The bitmapTransform function addresses the need to efficiently map or convert values stored in bitmaps to different values, enabling more flexible bitmap manipulations and analyses in ClickHouse.

How to use it

Use the bitmapTransform function by passing the original bitmap and a transformation expression or mapping that defines how the array of values should be converted to a new array. The function returns a new bitmap reflecting the transformed values.