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 <chalcy.r...@careerbuilder.com>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
