v.23.3Improvement
Support for Big Integers, Flexible Key Types in Map, and Enhanced DateTime64 Precision
Support big integers(U)Int128/(U)Int256,Mapwith any key type andDateTime64with any precision (not only 3 and 6). #48119 (Kruglov Pavel).
Why it matters
This feature expands the data type capabilities in ClickHouse, allowing users to store and process very large integer values, use more flexible map key types, and work with date-time values at any desired precision. This improves data modeling flexibility and precision for time series and complex datasets.How to use it
Users can now define columns using the new big integer types likeInt128 or UInt256, create Map columns with any supported key type, and specify DateTime64(precision) with custom precision values beyond the previous limits of 3 or 6 decimal places in their table schemas and queries.