[ https://issues.apache.org/jira/browse/HIVE-19832?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rafael Mourao updated HIVE-19832: --------------------------------- Environment: (was: :0 jdbc:hive2://> CREATE TABLE t (x INT) PARTITIONED BY (y INT); 0: jdbc:hive2://> SELECT * FROM t; 0: jdbc:hive2://> SELECT * FROM t WHERE y IS NOT NULL; +------+------+--+ | t.x | t.y | +------+------+--+ +------+------+--+ 0: jdbc:hive2://> SET hive.optimize.ppd=false; 0: jdbc:hive2://> SELECT * FROM t WHERE y IS NOT NULL; Error: Error while compiling statement: FAILED: SemanticException [Error 10041]: No partition predicate found for Alias "t" Table "t" (state=42000,code=10041)) > Query fails when disabling PPD optimization > ------------------------------------------- > > Key: HIVE-19832 > URL: https://issues.apache.org/jira/browse/HIVE-19832 > Project: Hive > Issue Type: Bug > Components: Logical Optimizer > Affects Versions: 1.1.0 > Reporter: Rafael Mourao > Priority: Minor > > Query fails when disabling PPD optimization (necessary until > https://issues.apache.org/jira/browse/HIVE-19652 is solved): > > :0 jdbc:hive2://> CREATE TABLE t (x INT) PARTITIONED BY (y INT); > 0: jdbc:hive2://> SELECT * FROM t; > 0: jdbc:hive2://> SELECT * FROM t WHERE y IS NOT NULL; > +------+------+--+ > | t.x | t.y | > +------+------+--+ > +------+------+--+ > 0: jdbc:hive2://> SET hive.optimize.ppd=false; > 0: jdbc:hive2://> SELECT * FROM t WHERE y IS NOT NULL; > Error: Error while compiling statement: FAILED: SemanticException [Error > 10041]: No partition predicate found for Alias "t" Table "t" > (state=42000,code=10041) > > Current version: 1.1.0-cdh5.11.1 -- This message was sent by Atlassian JIRA (v7.6.3#76005)