[ 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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org