[HIVE-5788] select * fails for table after adding new columns using rcfile storage format

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.12.0
• Fix Version/s: 0.13.0
• Component/s: Serializers/Deserializers
• Assignee: Szehon Ho
• Reporter: Szehon Ho
• Created: 09/Nov/13 02:25
• Updated: 15/Nov/13 05:48
• Resolved: 15/Nov/13 05:48

Description

Given the following tables:

select * from two;
+-----+----+
| id  | a  |
+-----+----+
| 1   | a  |
| 2   | b  |
+-----+----+

 select * from three;
+-----+----+----+
| id  | a  | b  |
+-----+----+----+
| 1   | a  | z  |
| 2   | b  | y  |
| 3   | c  | x  |
+-----+----+----+

Execute the following steps:

create table testrc (id bigint, a string) stored as rcfile;
insert into table testrc select * from two;
select * from testrc;  //returns correctly
+-----+----+
| id  | a  |
+-----+----+
| 1   | a  |
| 2   | b  |
+-----+----+

 alter table testrc add columns (b string);
 insert into table testrc select * from three;
select * from testrc;  //new column returns null values
+-----+----+----+
| id  | a  | b  |
+-----+----+----+
| 1   | a  |    |
| 2   | b  |    |
| 1   | a  |    |
| 2   | b  |    |
| 3   | c  |    |
+-----+----+----+

Issue Links

• links to: Review request