I have a real time table with 3 day retention. And offline table that basically gets data loaded daily through an offline ingestion job . So for example, when I query for data for yesterday, data gets queried only from offline table despite real time table also having it? Just wanted to check that offline table always has the precedence over real time table?

https://dev.startree.ai/docs/pinot/concepts/time-boundary#:~:text=%E2%80%8B,specified%20for%20the%20offline%20table.