Hi Mahendar, That version 1.2 is reasonable.
One alternative is to create a new table (new_table) in Hive with columns from old_table plus the added column new_column as ORC etc Do an INSERT/SELECT from old_table to new_table INSERT INTO new_table SELECT *, <value_for_new_column) from old_table ALTER old_table RENAME to old_table_KEEP RENAME new_table TO ol_table That should work. Check the syntax. HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com On 16 May 2016 at 23:53, mahender bigdata <mahender.bigd...@outlook.com> wrote: > I'm on Hive 1.2 > > On 5/16/2016 12:02 PM, Matthew McCline wrote: > > > > What version of Hive are you on? > > > ------------------------------ > *From:* Mahender Sarangam <mahender.bigd...@outlook.com> > <mahender.bigd...@outlook.com> > *Sent:* Saturday, May 14, 2016 3:29 PM > *To:* user@hive.apache.org > *Subject:* Query Failing while querying on ORC Format > > Hi, > We are dumping our data into ORC Partition Bucketed table. We have loaded > almost 6 months data and here month is Partition by column. Now we have > modified ORC partition bucketed table schema. We have added 2 more columns > to the ORC table. Now whenever we are running select statement for older > month which has no columns( even though these columns are not part in > select clause, (projection column) ), it is throwing exception. > > There is JIRA bug for this kind of requirement has already been raised. > https://issues.apache.org/jira/browse/HIVE-11981 > > Can any one please tell me know alternative workaround for reading old > previous columns of ORC partition table. > > Thanks > > >
