@User perhaps you are looking for a solution being worked on in this issue: https://github.com/apache/pinot/issues/7229

Thanks for this.