[
https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14523214#comment-14523214
]
Aihua Xu commented on HIVE-10454:
---------------------------------
Before the change, we only check predicates on TableScan operator. PPD will
optimize to push the predicates down to TableScan in the most cases. If ppd
optimization is turned off or the predicates are nondeterministic, then
predicates are not pushed down to TableScan. See the following example,
{noformat}
TableScan
alias: srcpart
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
Filter Operator
predicate: (time <
to_date(date_add(from_unixtime(unix_timestamp()), 1))) (type: boolean)
{noformat}
Before the change, since we only check TableScan operator, then it will always
throw "No partition predicate found" exception. After the change, we will also
check the child "Filter Operator" and then it won't throw exceptions.
This predicate check tells the user if the query contains partition predicates
only and the actual partition pruning logic doesn't change.
I'm still checking input39.q unit test. It could be related to my change.
> 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
> Attachments: HIVE-10454.patch
>
>
> 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)
