Github user mgaido91 commented on a diff in the pull request:
https://github.com/apache/spark/pull/20717#discussion_r176750470
--- Diff:
sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/plans/logical/basicLogicalOperators.scala
---
@@ -341,6 +341,26 @@ case class Join(
case UsingJoin(_, _) => false
case _ => resolvedExceptNatural
}
+
+ override protected def constructAllConstraints: Set[Expression] = {
+ // additional constraints which are not enforced on the result of join
operations, but can be
+ // enforced either on the left or the right side
+ val additionalConstraints = joinType match {
+ case LeftAnti | LeftOuter if condition.isDefined =>
+
splitConjunctivePredicates(condition.get).flatMap(inferIsNotNullConstraints).filter(
+ _.references.subsetOf(right.outputSet))
+ case RightOuter if condition.isDefined =>
+
splitConjunctivePredicates(condition.get).flatMap(inferIsNotNullConstraints).filter(
+ _.references.subsetOf(left.outputSet))
+ case _ => Seq.empty[Expression]
+ }
+ super.constructAllConstraints ++ additionalConstraints
+ }
+
+ override lazy val constraints: ExpressionSet = ExpressionSet(
+ super.constructAllConstraints.filter { c =>
+ c.references.nonEmpty && c.references.subsetOf(outputSet) &&
c.deterministic
+ })
--- End diff --
thanks, I added some statements to the `ConstraintPropagationSuite`.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
