You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Hari Sankar Sivarama Subramaniyan (JIRA)" <ji...@apache.org> on 2014/08/17 10:23:18 UTC
[jira] [Commented] (HIVE-7417) select count(1) from ... where true;
fails in optimizer
[ 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)