xudong963 opened a new issue #1586: URL: https://github.com/apache/arrow-datafusion/issues/1586
**Describe the bug** Now datafusion doesn't process predicate pushdown correctly when there is `outer join`. I have discussed much in #1339 with @alamb. I think we ended up with a consensus. Notes that filtering conditions fall into two categories: `join condition and `where condition, I'll explain them separately in the following: 1.**join condition**: if the filter condition contains the **non-nullable-side** table, it can't be pushed down. 2.**where condition**: if the filter condition contains the **nullable-side** table, it can't be pushed down. But it's can be optimized, I describe how to process the case in #1585. **Additional context** related issues and pr: #1321 , #1585, #1339 -- 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]
