Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-1307

IllegalStateException while planning scalar subquery with complex correlated predicate

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • Impala 1.4.1
    • Impala 2.0
    • None

    Description

      The planner throws an IllegalStateException for the following scalar subquery:

      select 1 from alltypestiny t where (select sum(t1.id) from alltypesagg t1 inner join alltypes t2 on t1.id = t2.id where t1.id + t2.id = t.int_col) = t.int_col;
      
      
      I0924 17:12:10.272449 23963 Planner.java:184] finalize plan fragments
      I0924 17:12:10.272632 23963 jni-util.cc:177] java.lang.IllegalStateException
      	at com.google.common.base.Preconditions.checkState(Preconditions.java:129)
      	at com.cloudera.impala.planner.PlanFragment.finalize(PlanFragment.java:157)
      	at com.cloudera.impala.planner.Planner.createPlanFragments(Planner.java:186)
      	at com.cloudera.impala.service.Frontend.createExecRequest(Frontend.java:835)
      	at com.cloudera.impala.service.JniFrontend.createExecRequest(JniFrontend.java:137)
      
      

      Attachments

        Activity

          People

            alex.behm Alexander Behm
            dtsirogiannis Dimitris Tsirogiannis
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: