You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ashutosh Chauhan (JIRA)" <ji...@apache.org> on 2013/11/14 00:39:20 UTC
[jira] [Commented] (HIVE-5788) select * fails for table after
adding new columns using rcfile storage format
[ https://issues.apache.org/jira/browse/HIVE-5788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13821989#comment-13821989 ]
Ashutosh Chauhan commented on HIVE-5788:
----------------------------------------
+1
> 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.1.patch, 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)