Aihua Xu commented on HIVE-10454:

[~ashutoshc] Can you help review this patch as well?

Currently we only check TableScanOperator if it has any ColumnExpr. If the 
predicates are not pushed down, then you can't run the query in strict mode.

With the patch, we will check TableScanOperator and the children to see if they 
have any column match any partition key.  

> 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.2.patch, 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

Reply via email to