QQ, w.r.t to the way broker processes queries for hybrid tables. I see in the docs that query gets split between offline and realtime based on a timestamp. My take away from here is that data has to be continuous in offline table for all the previous days, is it possible to just make broker to query offline table for a window of time instead. Usecase is when we have some issue/holes in the data (lets say whole of yesterday). we want to be able to fix the segments only in that timerange, instead of maintaining a offline table alltogether. Are there alternative ways to fix this?

No, thats not possible and probably not a good feature to support (adds too much complexity). @Neha Pawar is working on automatically moving realtime segments to offline tables. Please see if that works for your use case. Once its in move to offline table, you can selectively replace data for any day

yup, saw the design doc posted , that should be helpful.