hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashish Kumar Singh (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-7446) Add support to ALTER TABLE .. ADD COLUMN to Avro backed tables
Date Tue, 05 Aug 2014 04:50:11 GMT

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

Mime
View raw message