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