This message was deleted.

Yes. You can create ingestion spec that uses a druid table as a source or if you are on Druid 24.x, even do this as an INSERT/REPLACE using SQL-based ingestion and SELECTing from a hourly table to insert into daily table and so forth. Since it is essentially a different ingestion process you can control rollup/aggregation at each step. You'll need to schedule the batches when you know the prior level is complete. i.e. schedule the daily load after the last hour of the day has been loaded to the hourly table.

To add to that, if you have Druid 24.0 have a look at the

Demo 2

demo query

Thanks @Sergio Ferragut and @Vadim. Let me have a look