check this thread. alter table add columns aternatives or hive refresh
that night help 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 14 May 2016 at 23:29, Mahender Sarangam <mahender.bigd...@outlook.com> wrote: > 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 >