You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Hyukjin Kwon (JIRA)" <ji...@apache.org> on 2016/10/08 11:10:21 UTC
[jira] [Commented] (SPARK-8403) Pruner partition won't effective
when partition field and fieldSchema exist in sql predicate
[ https://issues.apache.org/jira/browse/SPARK-8403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15557771#comment-15557771 ]
Hyukjin Kwon commented on SPARK-8403:
-------------------------------------
Hm, IIRC, this was fixed somewhere. Could you please try to reproduce in latest versions?
> Pruner partition won't effective when partition field and fieldSchema exist in sql predicate
> --------------------------------------------------------------------------------------------
>
> Key: SPARK-8403
> URL: https://issues.apache.org/jira/browse/SPARK-8403
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Reporter: Hong Shen
>
> When partition field and fieldSchema exist in sql predicates, pruner partition won't effective.
> Here is the sql,
> {code}
> select r.uin,r.vid,r.ctype,r.bakstr2,r.cmd from t_dw_qqlive_2090000026 r where r.cmd = 2 and (r.imp_date = 20150615 or and hour(r.itimestamp)>16)
> {code}
> Table t_dw_qqlive_2090000026 is partition by imp_date, itimestamp is a fieldSchema in t_dw_qqlive_2090000026.
> When run on hive, it will only scan data in partition 20150615, but if run on spark sql, it will scan the whole table t_dw_qqlive_2090000026.
--
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