v.22.2Improvement

Added DateTime64 Support in Dictionaries

Added support for DateTime64 data type in dictionaries. #33914 (Maksim Kita).
Added support for the DateTime64 data type in ClickHouse dictionaries.

Why it matters

This feature enables the use of high precision timestamp values with fractional seconds within dictionaries. It addresses the need for accurate and high-resolution time data in dictionary lookups, enhancing the capability and flexibility of dictionaries when working with time series or event data.

How to use it

To use DateTime64 in dictionaries, define the dictionary attribute or key column with the DateTime64 data type in your dictionary configuration files or queries. This allows dictionaries to store and query time values with fractional second precision seamlessly.