acelyc111 opened a new issue #4915: URL: https://github.com/apache/incubator-doris/issues/4915
**Is your feature request related to a problem? Please describe.** Suppose there are several DELETE operations on a table, and the table has only 1 tablet: ``` DELETE FROM tbl WHERE date < '2020-11-01'; DELETE FROM tbl WHERE date < '2020-11-02'; DELETE FROM tbl WHERE date < '2020-11-03'; DELETE FROM tbl WHERE date < '2020-11-04'; ``` There will be 4 delete predicates on a tablet, then launch a query on the table, doris will judge at most 4 predicates for every block or row, which is inefficient. **Describe the solution you'd like** We can merge the 4 predicates to one, for the example above, it should be: ``` DELETE FROM tbl WHERE date < '2020-11-04'; ``` We can implement it in class `DeleteHandler`. At the first step, the merge operation can be performed when delete predicate has conditions on only 1 column, we can merge **similar** predicates on the same column, the result is the union set for sub predicates. ``` op1 op2 result eq eq in eq in in ne ne not in ne not in not in ... ``` ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
