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).
Why it matters
This feature extends the compatibility ofASOF 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 useASOF JOIN as usual with keys of types UInt8, UInt16, Int8, Int16, or Date. No additional configuration or settings are required to enable this support.