The default MSE query planner does not support broker-side segment pruning today. The physical optimizer (v2 planner) does support it, but it does not have full feature parity with MSE yet (#15455).
We've noticed if one server becomes unhealthy through a gray failure, it can affect nearly all queries on the tenant since they fan out to all servers. Having pinot automatically route around unhealthy servers is being dealt with in #16253, but ideal the query planner also avoids querying servers unnecessarily.
cc @Jackie-Jiang @yashmayya
The default MSE query planner does not support broker-side segment pruning today. The physical optimizer (v2 planner) does support it, but it does not have full feature parity with MSE yet (#15455).
We've noticed if one server becomes unhealthy through a gray failure, it can affect nearly all queries on the tenant since they fan out to all servers. Having pinot automatically route around unhealthy servers is being dealt with in #16253, but ideal the query planner also avoids querying servers unnecessarily.
cc @Jackie-Jiang @yashmayya