[ 
https://issues.apache.org/jira/browse/KUDU-1659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Todd Lipcon resolved KUDU-1659.
-------------------------------
       Resolution: Invalid
    Fix Version/s: n/a

Turns out I was using Spark 1.5 which didn't support the necessary APIs. When I 
upgraded to Spark 1.6 the plans look right.

> Spark does not remove pushed predicates from Spark-side query plan
> ------------------------------------------------------------------
>
>                 Key: KUDU-1659
>                 URL: https://issues.apache.org/jira/browse/KUDU-1659
>             Project: Kudu
>          Issue Type: Improvement
>          Components: perf, spark
>    Affects Versions: 1.0.0
>            Reporter: Todd Lipcon
>             Fix For: n/a
>
>
> I ran the following Spark SQL query:
> {code}
> select count(*) from metrics where host = "foo.com"
> {code}
> I verified that this resulted in the predicate being pushed to Kudu. Once the 
> predicate is pushed, it's not necessary to evaluate again on the Spark side, 
> and in fact Spark doesn't need to select the column at all. However, Spark 
> appears to still be selecting the column and re-evaluating the same filter:
> {code}
> == Physical Plan ==
> TungstenAggregate(key=[], functions=[(count(1),mode=Final,isDistinct=false)], 
> output=[_c0#71L])
>  TungstenExchange SinglePartition
>   TungstenAggregate(key=[], 
> functions=[(count(1),mode=Partial,isDistinct=false)], 
> output=[currentCount#74L])
>    Project
>     Filter (host#0 = foo.com)
>      Scan org.apache.kudu.spark.kudu.KuduRelation@1d18e5ad[host#0]
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to