I have a use case where I want my data to be rolled up in druid in following manner :

• data belonging to <90 days should be rolled up Hourly
• data belonging to last 3-6 months should be rolled up Daily
• data belonging to last 6-12 months should be rolled up Monthly
• data belonging to last 1-3 years should be rolled up Yearly

How can I achieve this? I tried it by using mixed type granularitySpec, but it didn’t work.