v.21.6Improvement

Add ORDER BY WITH FILL Support for DateTime64

Add support for ORDER BY WITH FILL with DateTime64. #24016 (kevin wan).
Added support for ORDER BY WITH FILL functionality when using the DateTime64 data type.

Why it matters

This feature allows users to perform ordered queries with gaps filled in DateTime64 columns, enabling better handling of time series data with high precision timestamps by automatically filling missing intervals in the results.

How to use it

Use the ORDER BY ... WITH FILL clause on DateTime64 columns in your queries to get continuous results with missing DateTime64 values automatically filled. For example:

SELECT *
FROM table_name
ORDER BY datetime64_column WITH FILL

This will fill missing DateTime64 values in the specified order.