v.20.5Improvement

Support for (U)Int8, (U)Int16, and Date in ASOF JOIN

Support (U)Int8, (U)Int16, Date in ASOF JOIN. #11301 (Artem Zuikov).
Added support for UInt8, UInt16, Int8, Int16, and Date data types in ASOF JOIN operations.

Why it matters

This feature extends the compatibility of ASOF JOIN to smaller integer types and date values, enabling users to perform approximate join operations on datasets with these types without needing type conversions. It enhances flexibility and query efficiency when dealing with low-cardinality numeric or date dimensions.

How to use it

Simply use ASOF JOIN as usual with keys of types UInt8, UInt16, Int8, Int16, or Date. No additional configuration or settings are required to enable this support.