Add OOM query killing in multi-stage query engine

[gortiz]

Pinot has the ability to protect itself from OOM when executing heavy queries by enabling automatic query killing. But this feature is limited to single-stage queries.

We need to add support for multi-stage queries.

[hpvd]

@Jackie-Jiang what do think of introducing a new Resiliency label for issues like this one? Would be fitting to all issues making pinot more robust and give users a better more stable experience out of the box

edit: added a parent for issues of this type: https://github.com/apache/pinot/issues/13456

[siddharthteotia]

Yes Resiliency label would be useful. In fact, I think we have a bunch of resiliency related open / in-progress work that should ideally be coupled under resiliency label.

[yashmayya]

Fixed in https://github.com/apache/pinot/pull/13598 / https://github.com/apache/pinot/pull/13955.