You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Aman Sinha (Jira)" <ji...@apache.org> on 2020/04/27 22:42:00 UTC
[jira] [Resolved] (IMPALA-9693) Predicate in the ORDER BY clause
causes failure with cnf rewrite enabled
[ https://issues.apache.org/jira/browse/IMPALA-9693?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aman Sinha resolved IMPALA-9693.
--------------------------------
Resolution: Fixed
> Predicate in the ORDER BY clause causes failure with cnf rewrite enabled
> ------------------------------------------------------------------------
>
> Key: IMPALA-9693
> URL: https://issues.apache.org/jira/browse/IMPALA-9693
> Project: IMPALA
> Issue Type: Bug
> Components: Frontend
> Affects Versions: Impala 3.4.0
> Reporter: Aman Sinha
> Assignee: Aman Sinha
> Priority: Major
> Fix For: Impala 4.0
>
>
> When enable_cnf_rewrites is set to true, following query which has a predicate in the ORDER BY clause encounters failure. This is very similar to IMPALA-9620 except the predicate occurs in the ORDER BY.
> {noformat}
> set enable_cnf_rewrites = true;
> select l_quantity, if(l_quantity < 5 or l_quantity > 45, 'invalid', 'valid')
> from lineitem
> order by l_quantity, if(l_quantity < 5 or l_quantity > 45, 'invalid', 'valid')
> limit 5
> ERROR: IllegalStateException: null
> {noformat}
> Stack trace:
> {noformat}
> java.lang.IllegalStateException
> at com.google.common.base.Preconditions.checkState(Preconditions.java:492)
> at org.apache.impala.analysis.SlotRef.getIdsHelper(SlotRef.java:229)
> at org.apache.impala.analysis.Expr.getIdsHelper(Expr.java:1286)
> at org.apache.impala.analysis.Expr.getIdsHelper(Expr.java:1286)
> at org.apache.impala.analysis.Expr.getIds(Expr.java:1279)
> at org.apache.impala.rewrite.ConvertToCNFRule.convertToCNF(ConvertToCNFRule.java:111)
> at org.apache.impala.rewrite.ConvertToCNFRule.apply(ConvertToCNFRule.java:86)
> at org.apache.impala.rewrite.ExprRewriter.applyRuleBottomUp(ExprRewriter.java:85)
> at org.apache.impala.rewrite.ExprRewriter.applyRuleBottomUp(ExprRewriter.java:83)
> at org.apache.impala.rewrite.ExprRewriter.applyRuleRepeatedly(ExprRewriter.java:71)
> at org.apache.impala.rewrite.ExprRewriter.rewrite(ExprRewriter.java:55)
> at org.apache.impala.analysis.SelectStmt.rewriteCheckOrdinalResult(SelectStmt.java:1043)
> at org.apache.impala.analysis.SelectStmt.rewriteExprs(SelectStmt.java:1068)
> at org.apache.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:472)
> at org.apache.impala.analysis.AnalysisContext.analyzeAndAuthorize(AnalysisContext.java:415)
> at org.apache.impala.service.Frontend.doCreateExecRequest(Frontend.java:1530)
> at org.apache.impala.service.Frontend.getTExecRequest(Frontend.java:1497)
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org