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)

Reply via email to