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

Impala throws IllegalStateException when inserting data into a partition while select subquery group by partition columns

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Impala 2.2.4
    • Fix Version/s: Impala 2.2.9
    • Component/s: None
    • Labels:
      None

      Description

      Please see below example for reproduce steps:

      [host-10-17-80-41.coe.cloudera.com:21000] > create table part_test (col int) partitioned by (p int);
      Query: create table part_test (col int) partitioned by (p int)
      
      Fetched 0 row(s) in 0.15s
      [host-10-17-80-41.coe.cloudera.com:21000] > create table test(col1 int, p int);
      Query: create table test(col1 int, p int)
      
      Fetched 0 row(s) in 0.14s
      [host-10-17-80-41.coe.cloudera.com:21000] > insert overwrite table part_test partition (p=1) select max(col1) as col from test group by p;
      Query: insert overwrite table part_test partition (p=1) select max(col1) as col from test group by p
      ERROR: IllegalStateException: null
      

      The exception stack trace is:

      I1011 06:21:02.950307 21431 jni-util.cc:177] java.lang.IllegalStateException
      	at com.google.common.base.Preconditions.checkState(Preconditions.java:129)
      	at com.cloudera.impala.planner.DataPartition.<init>(DataPartition.java:49)
      	at com.cloudera.impala.planner.DistributedPlanner.createInsertFragment(DistributedPlanner.java:230)
      	at com.cloudera.impala.planner.Planner.createPlan(Planner.java:82)
      	at com.cloudera.impala.service.Frontend.createExecRequest(Frontend.java:851)
      	at com.cloudera.impala.service.JniFrontend.createExecRequest(JniFrontend.java:147)
      

        Attachments

          Activity

            People

            • Assignee:
              HuaisiXu Huaisi Xu
              Reporter:
              Yibing Yibing Shi
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: