EmmyMiao87 opened a new issue #2155: Push down predicate when equal join predicate is null safe URL: https://github.com/apache/incubator-doris/issues/2155 **Is your feature request related to a problem? Please describe.** The hash join will push down a In predicate to the left child when plan is executed. This is a optimization which avoid to scan the total data in left child. However, if there is null in left child, the in predicate will filter it while the '<=>' operator need it. So, if there are null-safe equal join predicates in hash join, this optimization has been cancelled. **Describe the solution you'd like** This optimization should be effective for null-safe hash join too. The predicate which is used to pushed down should be change to `in or isnull()`
---------------------------------------------------------------- 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 With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org