You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2021/11/15 06:08:16 UTC
[GitHub] [incubator-doris] killxdcj opened a new issue #7120: [Feature] Add OrToIn Expr rewrite rule.
killxdcj opened a new issue #7120:
URL: https://github.com/apache/incubator-doris/issues/7120
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Description
`OR` cannot be pushdown on the storage side, we can make the pushdown take effect by rewriting it to `IN`.
### Use case
select * from table where k1 = 1 or k1 = 2 or k1 in (3, 4, 5)
Rewriting `OR` to `IN` can significantly improve performance.
select * from table where k1 in (1, 2, 3, 4, 5)
### Related issues
_No response_
### Are you willing to submit PR?
- [X] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] EmmyMiao87 commented on issue #7120: [Feature] Add OrToIn Expr rewrite rule.
Posted by GitBox <gi...@apache.org>.
EmmyMiao87 commented on issue #7120:
URL: https://github.com/apache/incubator-doris/issues/7120#issuecomment-968604911
Doris has included a rule that is responsible for merging the predicates in the or clauses called "ExtractCommonFactorsRule".
But I just tested it and he didn't cover this situation while it should be.
My suggestion is to optimize this rule.
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org