Davies Liu created SPARK-13354:
----------------------------------
Summary: Push filter throughout outer join when the condition can
filter out empty row
Key: SPARK-13354
URL: https://issues.apache.org/jira/browse/SPARK-13354
Project: Spark
Issue Type: Improvement
Components: SQL
Reporter: Davies Liu
Assignee: Davies Liu
For a query
{code}
select * from a left outer join b on a.a = b.a where b.b > 10
{code}
The condition `b.b > 10` will filter out all the row that the b part of it is
empty.
In this case, we should use Inner join, and push down the filter into b.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
