v.1.1.54289New Feature
Added aggregate functions for bitwise operations
Added aggregate functionsgroupBitAnd,groupBitOr, andgroupBitXor(for compatibility, they are also available under the namesBIT_AND,BIT_OR, andBIT_XOR).
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.