Hi does anyone explain me about the intermediary stage in detail? And what is intermediary server 1,2,3 is it a multistage engine works on background when its enabled?

Hi, i am not sure i understand your question. have you read the reference designs in pinot doc?

Yes , What is Intermidate compute stage?

one examle is the join stage in the design doc

Ok got it