This message was deleted.

The simplest way to achieve this is likely using compaction jobs with a changing

queryGranularity

https://druid.apache.org/docs/latest/data-management/compaction.html#query-granularity-handling

Thank you sir 🙂

you can also use SQL-based approach: https://druid.apache.org/docs/latest/multi-stage-query/examples.html#replace-for-reindexing-an-existing-datasource-into-itself

Damn, I like that one