[
https://issues.apache.org/jira/browse/HIVE-5788?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Szehon Ho updated HIVE-5788:
----------------------------
Description:
Given the following tables:
{code}
select * from two;
+-----+----+
| id | a |
+-----+----+
| 1 | a |
| 2 | b |
+-----+----+
select * from three;
+-----+----+----+
| id | a | b |
+-----+----+----+
| 1 | a | z |
| 2 | b | y |
| 3 | c | x |
+-----+----+----+
{code}
Execute the following steps:
{code}
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 | |
+-----+----+----+
{code}
was:
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 | |
+-----+----+----+
> 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
> Affects Versions: 0.12.0
> Reporter: Szehon Ho
> Assignee: Szehon Ho
> Attachments: HIVE-5788.patch
>
>
> Given the following tables:
> {code}
> select * from two;
> +-----+----+
> | id | a |
> +-----+----+
> | 1 | a |
> | 2 | b |
> +-----+----+
> select * from three;
> +-----+----+----+
> | id | a | b |
> +-----+----+----+
> | 1 | a | z |
> | 2 | b | y |
> | 3 | c | x |
> +-----+----+----+
> {code}
> Execute the following steps:
> {code}
> 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 | |
> +-----+----+----+
> {code}
--
This message was sent by Atlassian JIRA
(v6.1#6144)
