xiangfu0 commented on PR #14758: URL: https://github.com/apache/pinot/pull/14758#issuecomment-2580630360
> Only the queries with right `DISTINCT` and no right project regular join can be rewritten to SEMI join. IMO we shouldn't allow such auto-rewrite because it doesn't guarantee better performance. Queries written as regular join should be executed as regular join; written as semi join should be executed as semi join. The query mentioned in the PR description is already a Semi join in the query plan. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
