Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> add  column to hive table


Copy link to this message
-
RE: add column to hive table
Good idea! Ashwanth.  See if this can work for me and let you know.

Thanks,
CHalcy

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:
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?
Thanks,
Chalcy

--

Ashwanth Kumar / ashwanthkumar.in<http://ashwanthkumar.in/>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB