[ https://issues.apache.org/jira/browse/HIVE-22634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17164865#comment-17164865 ]
Zhihua Deng edited comment on HIVE-22634 at 8/17/20, 3:22 AM: -------------------------------------------------------------- [~EdisonWang] are you working on this? I'm interested in it, can I try this? was (Author: dengzh): [~EdisonWang] are you working on this? I'm interested in it, can you try this? > 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 > Assignee: EdisonWang > Priority: Minor > Labels: pull-request-available > Attachments: HIVE-22634.patch > > Time Spent: 1h > Remaining Estimate: 0h > > 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)