v.23.3Improvement

Support for Big Integers, Flexible Key Types in Map, and Enhanced DateTime64 Precision

Support big integers (U)Int128/(U)Int256, Map with any key type and DateTime64 with any precision (not only 3 and 6). #48119 (Kruglov Pavel).
Added support for big integers (U)Int128 and (U)Int256, Map data types with any key type, and DateTime64 with arbitrary precision beyond just 3 and 6 digits.

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 like Int128 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.