Mitesh created SPARK-17636:
------------------------------
Summary: Parquet filter push down doesn't handle struct fields
Key: SPARK-17636
URL: https://issues.apache.org/jira/browse/SPARK-17636
Project: Spark
Issue Type: Bug
Components: Spark Core, SQL
Affects Versions: 1.6.2
Reporter: Mitesh
scala> hc.read.parquet("s3a://some/parquet/file").select("day_timestamp",
"sale_id")
res5: org.apache.spark.sql.DataFrame = [day_timestamp:
struct<timestamp:bigint,timezone:string>, sale_id: bigint]
scala> res5.filter("sale_id > 4").queryExecution.executedPlan
res9: org.apache.spark.sql.execution.SparkPlan =
Filter[23814] [args=(sale_id#86324L >
4)][outPart=UnknownPartitioning(0)][outOrder=List()]
+- Scan ParquetRelation[day_timestamp#86302,sale_id#86324L] InputPaths:
s3n://aiq.data.pipeline.prod-restart/gilt/fact_clickstream_page_views/annotated/20150917_123800634_zzz_937571e7_0161_48e4_8c8c_7ce5600ae933,
PushedFilters: [GreaterThan(sale_id,4)]
scala> res5.filter("day_timestamp.timestamp > 4").queryExecution.executedPlan
res10: org.apache.spark.sql.execution.SparkPlan =
Filter[23815] [args=(day_timestamp#86302.timestamp >
4)][outPart=UnknownPartitioning(0)][outOrder=List()]
+- Scan ParquetRelation[day_timestamp#86302,sale_id#86324L] InputPaths:
s3n://aiq.data.pipeline.prod-restart/gilt/fact_clickstream_page_views/annotated/20150917_123800634_zzz_937571e7_0161_48e4_8c8c_7ce5600ae933
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
