[jira] [Created] (IMPALA-9693) Predicate in the ORDER BY clause causes failure with cnf rewrite enabled

[Aman Sinha (Jira)]

Aman Sinha created IMPALA-9693:
----------------------------------

             Summary: 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
             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)