How does druid handle queries on archived data (tiered storage)? [closed]

We have a requirement where we need to store 1 week of data in the "hot" tier, upto 1 month of data in the "cold" tier. For data that is older than 1 month, we don't want to retain that in historical nodes. so I understand that we can achieve that by configuring data retention rules(dropByPeriod).


This is a companion discussion topic for the original entry at https://stackoverflow.com/questions/71390775/how-does-druid-handle-queries-on-archived-data-tiered-storage