hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chalcy Raja <>
Subject RE: add column to hive table
Date Wed, 02 May 2012 00:38:15 GMT
In my situation, the tables I was importing into hive are daily tables.  Couple of columns
were added in a month which are not added to the end of the table. Also one field got dropped
in between. Also I have data for a year.

Anyway the way, I handled is, created an external table on top of the older data and sqoop
imported specifying columns in the query tag of the sqoop import into the hive external table.
 Had to have three different sqoop imports for the three periods.  Anyway got them all together
so nobody will notice the change :)


From: Chalcy Raja []
Sent: Monday, April 30, 2012 9:08 PM
Subject: RE: add column to hive table

Good idea! Ashwanth.  See if this can work for me and let you know.


From: [] On Behalf Of Ashwanth Kumar
Sent: Monday, April 30, 2012 6:55 PM
Subject: Re: add column to hive table

You can only add columns at the end. If you are using the native SerDe try

ALTER TABLE tbl_name REPLACE COLUMNS (column1 int, mynewcolumn string, column2 int);

More information on Hive Wiki -
On Tue, May 1, 2012 at 4:12 AM, Chalcy Raja <<>>
Hi all,
Adding a column by alter table mytable add column (mynewcolumn string); works well for me.
 This adds a field to the end of the schema.
Is there a way to add a column in between two columns?


Ashwanth Kumar /<>

View raw message