[
https://issues.apache.org/jira/browse/HIVE-7446?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14085794#comment-14085794
]
Ashish Kumar Singh commented on HIVE-7446:
------------------------------------------
[~szehon] Do you something like this will be a good test?
<code>
CREATE TABLE doctors (
number int,
first_name string,
last_name string)
STORED AS AVRO;
LOAD DATA LOCAL INPATH '../../data/files/doctors.avro' INTO TABLE doctors;
CREATE TABLE doctors_copy (
number int,
first_name string)
STORED AS AVRO;
INSERT INTO TABLE doctors_copy SELECT number, first_name FROM doctors;
ALTER TABLE doctors_copy ADD COLUMNS (last_name string);
LOAD DATA LOCAL INPATH '../../data/files/doctors.avro' OVERWRITE INTO TABLE
doctors_copy;
SELECT * FROM doctors_copy;
<code>
> Add support to ALTER TABLE .. ADD COLUMN to Avro backed tables
> --------------------------------------------------------------
>
> Key: HIVE-7446
> URL: https://issues.apache.org/jira/browse/HIVE-7446
> Project: Hive
> Issue Type: New Feature
> Reporter: Ashish Kumar Singh
> Assignee: Ashish Kumar Singh
> Attachments: HIVE-7446.patch
>
>
> HIVE-6806 adds native support for creating hive table stored as Avro. It
> would be good to add support to ALTER TABLE .. ADD COLUMN to Avro backed
> tables.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
