[IMPALA-2540] IllegalStateException planning nested query with several joins

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 2.3.0
• Fix Version/s: Impala 2.7.0
• Component/s: Frontend
• Labels: nested_types planner query_generator
• Environment: commit d0d7dc03ccea2f072a26e55ead6fffc6e0baf9a6
• Target Version: Impala 2.7.0
• Assignee: Alexander Behm
• Reporter: casey
• Created: 13/Oct/15 04:19
• Updated: 25/Aug/16 00:49
• Resolved: 25/Aug/16 00:49

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)