[HIVE-7417] select count(1) from ... where true; fails in optimizer

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.14.0
• Fix Version/s: 0.14.0
• Component/s: Logical Optimizer, Query Processor
• Assignee: Hari Sankar Sivarama Subramaniyan
• Reporter: Gopal Vijayaraghavan
• Created: 15/Jul/14 22:54
• Updated: 13/Nov/14 19:41
• Resolved: 22/Oct/14 17:55

Description

Simple queries which fail are

 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)

Issue Links

• relates to: HIVE-6934 PartitionPruner doesn't handle top level constant expression correctly