spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Apache Spark (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (SPARK-6742) Spark pushes down filters in old parquet path that reference partitioning columns
Date Tue, 07 Apr 2015 12:28:12 GMT

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

Apache Spark reassigned SPARK-6742:
-----------------------------------

    Assignee:     (was: Apache Spark)

> Spark pushes down filters in old parquet path that reference partitioning columns
> ---------------------------------------------------------------------------------
>
>                 Key: SPARK-6742
>                 URL: https://issues.apache.org/jira/browse/SPARK-6742
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 1.2.1
>            Reporter: Yash Datta
>
> Create a table with multiple fields partitioned on 'market' column. run a query like
: 
> SELECT start_sp_time, end_sp_time, imsi, imei,  enb_common_enbid FROM csl_data_parquet
WHERE (((technology = 'FDD') AND (bandclass = '800') AND (region = 'R15') AND (market = 'LA
metro')) OR ((technology = 'FDD') AND (bandclass = '1900') AND (region = 'R15') AND (market
= 'Indianapolis'))) AND start_sp_time >= 1.4158368E9 AND end_sp_time < 1.4159232E9 AND
dt >= '2014-11-13-00-00' AND dt < '2014-11-14-00-00' ORDER BY end_sp_time DESC LIMIT
100
> The or filter is pushed down in this case , resulting in column not found exception from
parquet 



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

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org


Mime
View raw message