You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@spark.apache.org by Ravi Ravi <i....@gmail.com> on 2015/09/15 19:32:55 UTC

Predicate push-down bug?

Turning on predicate pushdown for ORC datasources results in a
NoSuchElementException:

scala> val df = sqlContext.sql("SELECT name FROM people WHERE age < 15")
df: org.apache.spark.sql.DataFrame = [name: string]

scala> sqlContext.setConf("spark.sql.orc.filterPushdown", "*true*")

scala> df.explain
== Physical Plan ==
*java.util.NoSuchElementException*

Disabling the pushdown makes things work again:

scala> sqlContext.setConf("spark.sql.orc.filterPushdown", "*false*")

scala> df.explain
== Physical Plan ==
Project [name#6]
 Filter (age#7 < 15)
  Scan
OrcRelation[file:/home/mydir/spark-1.5.0-SNAPSHOT/test/people][name#6,age#7]

Have any of you run into this problem before? Is a fix available?

Thanks,
Ravi

Re: Predicate push-down bug?

Posted by Ram Sriharsha <sr...@gmail.com>.

Hi Ravi

This does look like a bug.. I have created a JIRA to track it here:

https://issues.apache.org/jira/browse/SPARK-10623

Ram

On Tue, Sep 15, 2015 at 10:47 AM, Ram Sriharsha <sr...@gmail.com>
wrote:

> Hi Ravi
>
> Can you share more details? What Spark version are you running?
>
> Ram
>
> On Tue, Sep 15, 2015 at 10:32 AM, Ravi Ravi <i....@gmail.com>
> wrote:
>
>> Turning on predicate pushdown for ORC datasources results in a
>> NoSuchElementException:
>>
>> scala> val df = sqlContext.sql("SELECT name FROM people WHERE age < 15")
>> df: org.apache.spark.sql.DataFrame = [name: string]
>>
>> scala> sqlContext.setConf("spark.sql.orc.filterPushdown", "*true*")
>>
>> scala> df.explain
>> == Physical Plan ==
>> *java.util.NoSuchElementException*
>>
>> Disabling the pushdown makes things work again:
>>
>> scala> sqlContext.setConf("spark.sql.orc.filterPushdown", "*false*")
>>
>> scala> df.explain
>> == Physical Plan ==
>> Project [name#6]
>>  Filter (age#7 < 15)
>>   Scan
>> OrcRelation[file:/home/mydir/spark-1.5.0-SNAPSHOT/test/people][name#6,age#7]
>>
>> Have any of you run into this problem before? Is a fix available?
>>
>> Thanks,
>> Ravi
>>
>>
>

Re: Predicate push-down bug?

Posted by Ram Sriharsha <sr...@gmail.com>.

Hi Ravi

Can you share more details? What Spark version are you running?

Ram

On Tue, Sep 15, 2015 at 10:32 AM, Ravi Ravi <i....@gmail.com>
wrote:

> Turning on predicate pushdown for ORC datasources results in a
> NoSuchElementException:
>
> scala> val df = sqlContext.sql("SELECT name FROM people WHERE age < 15")
> df: org.apache.spark.sql.DataFrame = [name: string]
>
> scala> sqlContext.setConf("spark.sql.orc.filterPushdown", "*true*")
>
> scala> df.explain
> == Physical Plan ==
> *java.util.NoSuchElementException*
>
> Disabling the pushdown makes things work again:
>
> scala> sqlContext.setConf("spark.sql.orc.filterPushdown", "*false*")
>
> scala> df.explain
> == Physical Plan ==
> Project [name#6]
>  Filter (age#7 < 15)
>   Scan
> OrcRelation[file:/home/mydir/spark-1.5.0-SNAPSHOT/test/people][name#6,age#7]
>
> Have any of you run into this problem before? Is a fix available?
>
> Thanks,
> Ravi
>
>