Thanks Wenli for quick reply. Yes, we have a requirement exactly the same which you mentioned.
I have tried the query which you provided but got an error saying that "Invalid column reference for newColumn possible columns are ......" Thanks Venkatesh On Monday, August 10, 2015, Wangwenli <wangwe...@huawei.com> wrote: > something like this? > create table newTable as select oldTable.*, newCol1,newCol2 from oldTable; > > ------------------------------ > wenli > Regards > > > *From:* venkatesh b > <javascript:_e(%7B%7D,'cvml','venkateshmailingl...@gmail.com');> > *Date:* 2015-08-10 20:54 > *To:* user <javascript:_e(%7B%7D,'cvml','user@hive.apache.org');> > *Subject:* How to create new table like existing with an extra column in > single query. > Hello, > > In hive we got a need that we need to create a new table like the old > table with an extra column at run time. This must be done in a single > query. No second query with alter table statement. > > Query like: > > Create table new_table like old_table , new_column datatype; > > Please help me out, searched in many forums but not found the solution. > Please inform me if any other information is needed. > > Thanks & Regards > Venkatesh > >