[
https://issues.apache.org/jira/browse/HIVE-22634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
EdisonWang updated HIVE-22634:
------------------------------
Description:
When filter is optimized to False on a partition table, it will throw
improperly SemanticException reporting that there is no partition predicate
found.
The step to reproduce is
{code:java}
set hive.strict.checks.no.partition.filter=true;
CREATE TABLE test(id int, name string)PARTITIONED BY (`date` string);
select * from test where `date` = '20191201' and 1<>1;
{code}
The above sql will throw "Queries against partitioned tables without a
partition filter" exception.
was:
When filter is optimized to False on a partition table, it will throw
improperly SemanticException reporting that there is no partition predicate
found.
The step to reproduce is
```
set hive.strict.checks.no.partition.filter=true;
CREATE TABLE test(id int, name string)PARTITIONED BY (`date` string);
select * from test where `date` = '20191201' and 1<>1;
```
The above sql will throw "Queries against partitioned tables without a
partition filter" exception.
> Improperly SemanticException when filter is optimized to False on a partition
> table
> -----------------------------------------------------------------------------------
>
> Key: HIVE-22634
> URL: https://issues.apache.org/jira/browse/HIVE-22634
> Project: Hive
> Issue Type: Improvement
> Reporter: EdisonWang
> Priority: Minor
>
> When filter is optimized to False on a partition table, it will throw
> improperly SemanticException reporting that there is no partition predicate
> found.
> The step to reproduce is
> {code:java}
> set hive.strict.checks.no.partition.filter=true;
> CREATE TABLE test(id int, name string)PARTITIONED BY (`date` string);
> select * from test where `date` = '20191201' and 1<>1;
> {code}
>
> The above sql will throw "Queries against partitioned tables without a
> partition filter" exception.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
