[ 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)