@hive.apache.org
Cc: ashwanthku...@googlemail.com
Subject: Re: add column to hive table
you probably noticed this already, but if you add a column in the middle and it
did not exist in your older files then when you select from older dates you
will get wrong values in the wrong columns since you will be
**
>
> ** **
>
> *From:* Chalcy Raja [mailto:chalcy.r...@careerbuilder.com]
> *Sent:* Monday, April 30, 2012 9:08 PM
> *To:* user@hive.apache.org; ashwanthku...@googlemail.com
> *Subject:* RE: add column to hive table
>
> ** **
>
> Good idea! Ashwanth.
...@careerbuilder.com]
Sent: Monday, April 30, 2012 9:08 PM
To: user@hive.apache.org; ashwanthku...@googlemail.com
Subject: RE: add column to hive table
Good idea! Ashwanth. See if this can work for me and let you know.
Thanks,
CHalcy
From: ashwanth.ku...@gmail.com [mailto:ashwanth.ku...@gmail.com
Good idea! Ashwanth. See if this can work for me and let you know.
Thanks,
CHalcy
From: ashwanth.ku...@gmail.com [mailto:ashwanth.ku...@gmail.com] On Behalf Of
Ashwanth Kumar
Sent: Monday, April 30, 2012 6:55 PM
To: user@hive.apache.org
Subject: Re: add column to hive table
You can only add
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, M
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
