v.21.6Improvement
Add ORDER BY WITH FILL Support for DateTime64
Why it matters
This feature allows users to perform ordered queries with gaps filled inDateTime64 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 theORDER 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 FILLThis will fill missing
DateTime64 values in the specified order.