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

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • Impala 2.2.4
    • Impala 2.2.9
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: