Asif created SPARK-55241:
----------------------------

             Summary: Idempotency of SQL Streaming involving Joins is broken if 
InferFiltersFromConstraint and PropagateEmptyRelation rules are added as part 
of Optimization rules 
                 Key: SPARK-55241
                 URL: https://issues.apache.org/jira/browse/SPARK-55241
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 4.1.1, 4.2.0
            Reporter: Asif


To fix issues SPARK-55185 and SPARK-55072, PropagateEmptyRelations and 
InferFiltersFromConstraints rules need to be added to the Operator 
Optimizations  Batch rules, which run for Fixed Iterations.

But addition of these 2 rules break the idempotency of SPARK SQL Streaming  in 
certain cases.

The issue is that in PropagateEmptyRelation,  the Join case is transformation 
is skipped ( rightly so , for streaming case), but the Filter case 
transformation is allowed. 

Ideally the Filter case transformation should also be suppressed for Streaming 
case, IMO.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to