[IMPALA-2533] Impala throws IllegalStateException when inserting data into a partition while select subquery group by partition columns

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.2.4
• Fix Version/s: Impala 2.2.9
• Target Version: Impala 2.2.9
• Assignee: Huaisi Xu
• Reporter: Yibing Shi
• Created: 12/Oct/15 11:16
• Updated: 07/Apr/16 02:02
• Resolved: 14/Nov/15 00:05

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)