What's New in ClickHouse 21.12
clickhouse.com › blog › enDec 16, 2021 · Since ClickHouse version 21.12 you can do it like this: ORDER BY EventDate WITH FILL STEP INTERVAL 1 MONTH INTERVALis a standard SQL operator, you can use SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER and YEAR. This is implemented by Anton Popovwho is the author of the "WITH FILL" feature. How does this help you?