v.23.4Improvement
bitCount function support for FixedString and String data types
bitCountfunction supportFixedStringandStringdata type. #49044 (flynn).
Why it matters
The feature extends thebitCount function to work with FixedString and String data types, allowing users to count the number of set bits (1s) in the binary representation of string data. This enhances functionality and flexibility when working with bit operations on string-based data in ClickHouse.How to use it
Use thebitCount function directly on columns or expressions of type FixedString or String. For example:SELECT bitCount(string_column) FROM table;