[jira] [Updated] (HIVE-19832) Query fails when disabling PPD optimization
[ https://issues.apache.org/jira/browse/HIVE-19832?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rafael Mourao updated HIVE-19832: - Priority: Major (was: Minor) > 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: Major > > 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 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)
[jira] [Updated] (HIVE-19832) Query fails when disabling PPD optimization
[ https://issues.apache.org/jira/browse/HIVE-19832?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rafael Mourao updated HIVE-19832: - Description: 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 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 was: 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 > 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 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)
[jira] [Updated] (HIVE-19832) Query fails when disabling PPD optimization
[ 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)