GitHub user sameeragarwal opened a pull request: https://github.com/apache/spark/pull/11594
[SPARK-13759][SQL] Add IsNotNull constraints for expressions with an inequality ## What changes were proposed in this pull request? This PR adds support for adding `IsNotNull` constraints from expressions with an `!==`. More specifically, if an operator has a condition on `a !== b`, we know that both `a` and `b` in the operator output can no longer be null. ## How was this patch tested? 1. Modified a test in `ConstraintPropagationSuite` to test for expressions with an inequality. 2. Added a test in `NullFilteringSuite` for making sure an Inner join with a "non-equal" condition appropriately filters out null from their input. cc @nongli You can merge this pull request into a Git repository by running: $ git pull https://github.com/sameeragarwal/spark isnotequal-constraints Alternatively you can review and apply these changes as the patch at: https://github.com/apache/spark/pull/11594.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #11594 ---- commit 21a9250e1266f3badbcc4b95bf2e7d276c22c5df Author: Sameer Agarwal <sam...@databricks.com> Date: 2016-03-09T01:45:20Z Add IsNotNull constraints for !== ---- --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. --- --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org