Gopal V created HIVE-7417: ----------------------------- Summary: select count(1) from ... where true; fails in optimizer Key: HIVE-7417 URL: https://issues.apache.org/jira/browse/HIVE-7417 Project: Hive Issue Type: Bug Affects Versions: 0.14.0 Reporter: Gopal V
Simple queries which fail are {code} select count(1) from store_sales where true and ss_sold_date='2001-01-02'; select count(1) from store_sales where true; FAILED: SemanticException java.lang.IllegalStateException: Unexpected non-null ExprNodeConstantDesc: true 14/07/15 15:55:59 [main]: ERROR ql.Driver: FAILED: SemanticException java.lang.IllegalStateException: Unexpected non-null ExprNodeConstantDesc: true org.apache.hadoop.hive.ql.parse.SemanticException: java.lang.IllegalStateException: Unexpected non-null ExprNodeConstantDesc: true at org.apache.hadoop.hive.ql.optimizer.pcr.PcrOpProcFactory$FilterPCR.process(PcrOpProcFactory.java:111) at org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(DefaultRuleDispatcher.java:90) at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatchAndReturn(DefaultGraphWalker.java:94) at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatch(DefaultGraphWalker.java:78) at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.walk(DefaultGraphWalker.java:132) at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.startWalking(DefaultGraphWalker.java:109) at org.apache.hadoop.hive.ql.optimizer.pcr.PartitionConditionRemover.transform(PartitionConditionRemover.java:86) at org.apache.hadoop.hive.ql.optimizer.Optimizer.optimize(Optimizer.java:146) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:9503) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:328) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:411) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:307) {code} -- This message was sent by Atlassian JIRA (v6.2#6252)