We are planning to have a hybrid table with much longer retention for offline table. We are ingesting realtime data from kafka. How can we move the segments from realtime table to offline table after 7 days?

we have an ongoing discussion here: https://github.com/apache/incubator-pinot/issues/5753

updated ticket with our use case. It's similar to one you have put into the description of the ticket.

This will be covered as part of tiered storage: https://github.com/apache/incubator-pinot/issues/5553