[GitHub] [arrow-datafusion] andygrove opened a new issue, #2739: Add `IsNotNull` filter to join inputs if one side of join condition does not allow null

[GitBox <gi...@apache.org>]

andygrove opened a new issue, #2739:
URL: https://github.com/apache/arrow-datafusion/issues/2739

   **Is your feature request related to a problem or challenge? Please describe what you are trying to do.**
   I am running a query something like this:
   
   ```sql
   SELECT * FROM foo JOIN bar ON foo.a = bar.b
   ```
   
   The `bar.b` column does not allow null values but `foo.a` does. Rows in `foo` where `a` is null can never match any row in `b` for the inner join case with an equi-join condition `foo.a = bar.b` so we should add a filter when reading `foo` to filter out rows where `a IS NULL` before we perform the join.
   
   **Describe the solution you'd like**
   As described.
   
   **Describe alternatives you've considered**
   None
   
   **Additional context**
   None
   


-- 
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: github-unsubscribe@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [arrow-datafusion] andygrove closed issue #2739: Add `IsNotNull` filter to join inputs if one side of join condition does not allow null

[GitBox <gi...@apache.org>]

andygrove closed issue #2739: Add `IsNotNull` filter to join inputs if one side of join condition does not allow null
URL: https://github.com/apache/arrow-datafusion/issues/2739


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org