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

["Sean Owen (JIRA)" <ji...@apache.org>]

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

Sean Owen resolved SPARK-23027.
-------------------------------
    Resolution: Invalid

> 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