[IMPALA-945] INSERT column reordering doesn't work with SELECT clause

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 1.3
• Fix Version/s: Impala 1.3.1
• Assignee: Henry Robinson
• Reporter: Henry Robinson
• Created: 11/Apr/14 22:29
• Updated: 18/Apr/14 03:56
• Resolved: 18/Apr/14 03:56

Description

create table perm(a int, b string);
insert into perm(b, a) values("str", 1);
select * from perm;
Query: select * from perm
ERRORS: 
Backend 0:Error converting column: 0 TO INT (Data is: foo)
file: hdfs://localhost:20500/test-warehouse/hank.db/perm/a3434a92e7916052-a3961350052f90b6_768277005_data.0
record: foo 2

+------+---+
| a    | b |
+------+---+
| NULL | 2 |
+------+---+
ERRORS: 
Backend 0:Error converting column: 0 TO INT (Data is: foo)
file: hdfs://localhost:20500/test-warehouse/hank.db/perm/a3434a92e7916052-a3961350052f90b6_768277005_data.0
record: foo 2

Analysis is fine, but the columns aren't getting permuted correctly in the backend.