[jira] [Commented] (SPARK-23027) optimizer a simple query using a non-existent data is too slow

["Takeshi Yamamuro (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-23027?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16321487#comment-16321487 ] 

Takeshi Yamamuro commented on SPARK-23027:
------------------------------------------

You tried v2.1? https://databricks.com/blog/2016/12/15/scalable-partition-handling-for-cloud-native-architecture-in-apache-spark-2-1.html
Either way, you need to first ask questions in the spark-user mailing list.

> optimizer a simple query using a non-existent data is too slow
> --------------------------------------------------------------
>
>                 Key: SPARK-23027
>                 URL: https://issues.apache.org/jira/browse/SPARK-23027
>             Project: Spark
>          Issue Type: Bug
>          Components: Optimizer
>    Affects Versions: 2.0.1
>            Reporter: wangminfeng
>
> When i use spark sql to do ad-hoc query, i have data partitioned by event_day, event_minute, event_hour, data is large enough，one day data is about 3T， we saved 3 month data.
> But when query use a non-existent day， get optimizedPlan is too slow.
> i use “sparkSession.sessionState.executePlan(logicalPlan).optimizedPlan” get optimized plan， for five minutes，i can not get it. Query is simple enough, like:
> SELECT
> event_day
> FROM db.table t1
> WHERE (t1.event_day='20170104' and t1.event_hour='23' and t1.event_minute='55')
> LIMIT 1



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

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