I am afraid AFAIK the old partitions cannot be modified as they are fixed in size. That is the existing partition file.
I agree this is very tedious. We should come up with a more flexible design for ORC tables. 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 17 May 2016 at 21:20, mahender bigdata <mahender.bigd...@outlook.com> wrote: > Hi Jorn, > > You mean to say try to add additional columns for the old partitions where > column are missing ? > > > > On 5/17/2016 7:25 AM, Jörn Franke wrote: > > I do not remember exactly, but I think it worked simply by adding a new > partition to the old table with the additional columns. > > On 17 May 2016, at 15:00, Mich Talebzadeh <mich.talebza...@gmail.com> > wrote: > > 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 > <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > <http://talebzadehmich.wordpress.com/>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 >> >> >> > >
