hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Szehon Ho (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-5788) select * fails for table after adding new columns using rcfile storage format
Date Wed, 13 Nov 2013 19:09:25 GMT

     [ 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)

Mime
View raw message