v.23.9Improvement

Better Integer Types Inference for Int64/UInt64 Fields, Including Nested Types and Functions

Official CH changelog text
Better integer types inference for Int64/UInt64 fields. Continuation of #53003. Now it works also for nested types like Arrays of Arrays and for functions like map/tuple. Issue: #51236. #54553 (Kruglov Pavel).
Improved integer type inference for Int64 and UInt64 fields, extending support to nested types such as Arrays of Arrays and functions like map and tuple.

Why it matters

This feature enhances the ClickHouse type inference mechanism to correctly and reliably infer Int64 and UInt64 types in more complex scenarios. It addresses issues where previous inference failed for nested data structures and certain functions, ensuring better type accuracy and query correctness for users working with nested or functional data types.

How to use it

This improvement is applied automatically as part of the ClickHouse engine's type inference during query processing. Users benefit from better integer type detection without any additional configuration or changes to their queries.

Related resources

PreviousNext