Sathiya Kumar created SPARK-22181:
-------------------------------------

             Summary: ReplaceExceptWithNotFilter if one or both of the datasets 
are fully derived out of Filters from a same parent
                 Key: SPARK-22181
                 URL: https://issues.apache.org/jira/browse/SPARK-22181
             Project: Spark
          Issue Type: New Feature
          Components: Optimizer, SQL
    Affects Versions: 2.2.0, 2.1.1
            Reporter: Sathiya Kumar
            Priority: Minor


While applying Except operator between two datasets, if one or both of the 
datasets are purely transformed using filter operations, then instead of 
rewriting the Except operator using expensive join operation, we can rewrite it 
using filter operation by flipping the filter condition of the right node.

!https://github.com/sathiyapk/Blog-Posts/blob/master/images/spark-optimizer/ReplaceExceptWithNotFilter-case1.png!

!https://github.com/sathiyapk/Blog-Posts/blob/master/images/spark-optimizer/ReplaceExceptWithNotFilter-case2.png!



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to