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

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 2.5.0, Impala 2.4.0, Impala 2.6.0
• Fix Version/s: Impala 2.7.0, Impala 2.6.2, Impala 2.5.4
• Component/s: Frontend
• Labels: regression usability
• Target Version: Impala 2.7.0, Impala 2.6.2, Impala 2.5.4
• Assignee: Alexander Behm
• Reporter: Huaisi Xu
• Created: 28/Jul/16 16:45
• Updated: 16/Sep/16 19:29
• Resolved: 31/Aug/16 13:36

Description

[localhost:21000] > create table part_test (col int) partitioned by (p int);
Query: create table part_test (col int) partitioned by (p int)
Query submitted at: 2016-07-28 09:39:36 (Coordinator: http://0.0.0.0:25000)
Query progress can be monitored at: http://0.0.0.0:25000/query_plan?query_id=964bb7eaf152615f:bc435fa67a22929f

Fetched 0 row(s) in 0.40s
[localhost:21000] > create table test(col1 int, p int);
Query: create table test(col1 int, p int)
Query submitted at: 2016-07-28 09:39:44 (Coordinator: http://0.0.0.0:25000)
Query progress can be monitored at: http://0.0.0.0:25000/query_plan?query_id=b40048f323fd53f:d94599b286e4da9d

Fetched 0 row(s) in 0.11s
[localhost: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
Query submitted at: 2016-07-28 09:39:51 (Coordinator: http://0.0.0.0:25000)
Query progress can be monitored at: http://0.0.0.0:25000/query_plan?query_id=704225bd24a68554:bc7b1374380872a2
Inserted 0 row(s) in 5.36s
[localhost:21000] > insert overwrite table part_test partition (p=1) [SHUFFLE] select max(col1) from test group by p;
Query: insert overwrite table part_test partition (p=1) [SHUFFLE] select max(col1) from test group by p
Query submitted at: 2016-07-28 09:40:08 (Coordinator: http://0.0.0.0:25000)
ERROR: IllegalStateException: null

[localhost:21000] > explain insert overwrite table part_test partition (p=1) [SHUFFLE] select max(col1) from test group by p;                 
Query: explain insert overwrite table part_test partition (p=1) [SHUFFLE] select max(col1) from test group by p
Query submitted at: 2016-07-28 09:41:38 (Coordinator: http://0.0.0.0:25000)
ERROR: IllegalStateException: null