Luka Zdravic created SPARK-61565:
------------------------------------

             Summary: Simplify or remove LEFT ASOF JOIN in EliminateOuterJoin
                 Key: SPARK-61565
                 URL: https://issues.apache.org/jira/browse/SPARK-61565
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 4.4.0
            Reporter: Luka Zdravic


EliminateOuterJoin does not handle AsOfJoin. A WHERE that drops NULL right 
columns, e.g. WHERE q.v IS NOT NULL, can turn a LEFT ASOF JOIN into an INNER 
ASOF JOIN. A LEFT ASOF JOIN whose right columns are unused can be removed, 
because it returns exactly one row per left row, e.g. SELECT count* FROM t LEFT 
ASOF JOIN q ...




--
This message was sent by Atlassian Jira
(v10.3.26#10030026)

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

Reply via email to