Good idea! Ashwanth. See if this can work for me and let you know.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ashwanth Kumar
Sent: Monday, April 30, 2012 6:55 PM
To: [EMAIL PROTECTED]
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 - https://cwiki.apache.org/Hive/languagemanual-ddl.html#LanguageManualDDL-Add%252FReplaceColumns
On Tue, May 1, 2012 at 4:12 AM, Chalcy Raja <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
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 / ashwanthkumar.in<http://ashwanthkumar.in/>