ankitsultana commented on issue #14196: URL: https://github.com/apache/pinot/issues/14196#issuecomment-2436149014
@gortiz : do you folks have some numbers which show the performance gains with this approach? And specifically which queries this will help? I have seen CTE reuse in query engines [like Presto](https://prestodb.io/blog/2024/10/01/cte-materialization-framework-in-presto/), but the bottlenecks there would be very different than what we have in most of the Pinot workloads (at least speaking from an Uber point of view). I suspect this can help if you have tiered storage (esp. for the Startree tiered storage plugin), but are there any other cases? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
