[HIVE-22634] Improperly SemanticException when filter is optimized to False on a partition table

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Labels: pull-request-available
• Assignee: EdisonWang
• Reporter: EdisonWang
• Created: 12/Dec/19 08:58
• Updated: 27/Feb/24 22:23

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

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.

Issue Links

• links to: GitHub Pull Request #865