v.1.1.54289New Feature

Added aggregate functions for bitwise operations

Added aggregate functions groupBitAnd, groupBitOr, and groupBitXor (for compatibility, they are also available under the names BIT_AND, BIT_OR, and BIT_XOR).
Introduces new aggregate functions for performing bitwise operations on grouped data: groupBitAnd, groupBitOr, and groupBitXor, also available as BIT_AND, BIT_OR, and BIT_XOR for compatibility.

Why it matters

These aggregate functions solve the problem of efficiently computing bitwise AND, OR, and XOR operations over multiple rows in a group. This adds essential bitwise aggregation capabilities that are useful for users needing to analyze and summarize bitwise data patterns within grouped datasets.

How to use it

Use these functions inside aggregation queries to apply bitwise operations across a group of rows. For example:
SELECT groupBitAnd(column_name) FROM table_name WHERE conditions GROUP BY grouping_column;

Similarly, you can use groupBitOr and groupBitXor in place of groupBitAnd. The functions are also available with the aliases BIT_AND, BIT_OR, and BIT_XOR.