[ https://issues.apache.org/jira/browse/HIVE-5788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13822635#comment-13822635 ]
Hive QA commented on HIVE-5788: ------------------------------- {color:green}Overall{color}: +1 all checks pass Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12613659/HIVE-5788.1.patch {color:green}SUCCESS:{color} +1 4612 tests passed Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/276/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/276/console Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12613659 > 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)