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

["Szehon Ho (JIRA)" <ji...@apache.org>]

Szehon Ho created HIVE-5788:
-------------------------------

             Summary: select * fails for table after adding new columns using rcfile storage format
                 Key: HIVE-5788
                 URL: https://issues.apache.org/jira/browse/HIVE-5788
             Project: Hive
          Issue Type: Bug
          Components: Serializers/Deserializers
            Reporter: Szehon Ho
            Assignee: Szehon Ho


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  |    |
+-----+----+----+



--
This message was sent by Atlassian JIRA
(v6.1#6144)