v.21.7New Feature

Added bitPositionsToArray Function in ClickHouse

Added function bitPositionsToArray. Closes #23792. Author [Kevin Wan] (@MaxWk). #25394 (Maksim Kita).
Added the function bitPositionsToArray to ClickHouse.

Why it matters

The bitPositionsToArray function provides a way to extract the positions of set bits in an integer as an array, enabling users to analyze bit patterns more easily within queries. This helps in scenarios where bitmask analysis or manipulation is required.

How to use it

You can use the bitPositionsToArray function directly in your SQL queries by passing an integer value to it. For example:

SELECT bitPositionsToArray(your_integer_column) FROM your_table;