You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Xuefu Zhang (JIRA)" <ji...@apache.org> on 2015/04/23 15:49:38 UTC
[jira] [Commented] (HIVE-10454) Query against partitioned table in
strict mode failed with "No partition predicate found" even if partition
predicate is specified.
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14509084#comment-14509084 ]
Xuefu Zhang commented on HIVE-10454:
------------------------------------
I'm not sure if in strict mode an equal condition on partition column is expected. Otherwise, the query can still span to all or a large number of partitions.
> Query against partitioned table in strict mode failed with "No partition predicate found" even if partition predicate is specified.
> -----------------------------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-10454
> URL: https://issues.apache.org/jira/browse/HIVE-10454
> Project: Hive
> Issue Type: Bug
> Reporter: Aihua Xu
> Assignee: Aihua Xu
>
> The following queries fail:
> {noformat}
> create table t1 (c1 int) PARTITIONED BY (c2 string);
> set hive.mapred.mode=strict;
> select * from t1 where t1.c2 < to_date(date_add(from_unixtime( unix_timestamp() ),1));
> {noformat}
> The query failed with "No partition predicate found for alias t1".
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)