[
https://issues.apache.org/jira/browse/SPARK-7267?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhongshuai Pei updated SPARK-7267:
----------------------------------
Description:
SQL
{quote}
select key from (select key,value from t1 limit 100) t2 limit 10
{quote}
Optimized Logical Plan before modifying
{quote}
== Optimized Logical Plan ==
Limit 10
Project [key#228]
Limit 100
MetastoreRelation default, t1, None
{quote}
Optimized Logical Plan after modifying
{quote}
== Optimized Logical Plan ==
Limit 10
Limit 100
Project [key#228]
MetastoreRelation default, t1, None
{quote}
> Push down Project when it's child is Limit
> -------------------------------------------
>
> Key: SPARK-7267
> URL: https://issues.apache.org/jira/browse/SPARK-7267
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 1.3.1
> Reporter: Zhongshuai Pei
> Priority: Critical
>
> SQL
> {quote}
> select key from (select key,value from t1 limit 100) t2 limit 10
> {quote}
> Optimized Logical Plan before modifying
> {quote}
> == Optimized Logical Plan ==
> Limit 10
> Project [key#228]
> Limit 100
> MetastoreRelation default, t1, None
> {quote}
> Optimized Logical Plan after modifying
> {quote}
> == Optimized Logical Plan ==
> Limit 10
> Limit 100
> Project [key#228]
> MetastoreRelation default, t1, None
> {quote}
--
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
