[
https://issues.apache.org/jira/browse/HIVE-7417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14099912#comment-14099912
]
Hari Sankar Sivarama Subramaniyan commented on HIVE-7417:
---------------------------------------------------------
This is most likely a duplicate of HIVE-6934. [~gopalv], can you try the latest
patch HIVE-6934.4.patch on this issue and see if it resolves the issue.
Thanks
Hari
> 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)
