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]