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

IllegalStateException planning nested query with several joins

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    Description

      Query

      use tpch_nested_parquet;
      
      Query: select 1
      FROM region.r_nations t1
      INNER JOIN customer t2 ON t2.c_nationkey = t1.pos
      INNER JOIN region t3 ON t3.r_comment = t2.c_address
      LEFT JOIN t2.c_orders t4
      INNER JOIN region t5 ON t5.r_regionkey = t2.c_custkey
      LEFT JOIN t4.item.o_lineitems t6 ON t6.item.l_returnflag = t4.item.o_orderpriority
      ERROR: IllegalStateException: null
      

      stacktrace

      I1012 21:14:56.738837 10233 jni-util.cc:177] java.lang.IllegalStateException
        at com.google.common.base.Preconditions.checkState(Preconditions.java:129)
        at com.cloudera.impala.planner.SingularRowSrcNode.init(SingularRowSrcNode.java:46)
        at com.cloudera.impala.planner.SingleNodePlanner.createTableRefNode(SingleNodePlanner.java:1459)
        at com.cloudera.impala.planner.SingleNodePlanner.createTableRefsPlan(SingleNodePlanner.java:791)
        at com.cloudera.impala.planner.SingleNodePlanner.createSubplan(SingleNodePlanner.java:862)
        at com.cloudera.impala.planner.SingleNodePlanner.createJoinPlan(SingleNodePlanner.java:546)
        at com.cloudera.impala.planner.SingleNodePlanner.createCheapestJoinPlan(SingleNodePlanner.java:378)
        at com.cloudera.impala.planner.SingleNodePlanner.createTableRefsPlan(SingleNodePlanner.java:804)
        at com.cloudera.impala.planner.SingleNodePlanner.createSelectPlan(SingleNodePlanner.java:630)
        at com.cloudera.impala.planner.SingleNodePlanner.createQueryPlan(SingleNodePlanner.java:229)
        at com.cloudera.impala.planner.SingleNodePlanner.createSingleNodePlan(SingleNodePlanner.java:135)
        at com.cloudera.impala.planner.Planner.createPlan(Planner.java:58)
        at com.cloudera.impala.service.Frontend.createExecRequest(Frontend.java:917)
      

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            alex.behm Alexander Behm
            caseyc casey
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment