Hi, I tried option 1 mentioned in trail mail and its working but due to this there are different access related tasks which needs to be done.
So can anyone reply on point 2 and 3, it will be helpful to understand other possible solution. Regards, Anup Tiwari On Fri, Sep 7, 2018 at 10:15 AM Anup Tiwari <anupsdtiw...@gmail.com> wrote: > Hi Gopal, > > Thanks for reply. I have 3 questions:- > > 1. We have our metastore DB for hive 2.1.1 in MySQL so when you say > the only way it works if you connect to the old metastore. > Does that mean, if we point hive 2.3.3 to same metastore DB as 2.1.1 , > this will work? > > 2. Is this feature available in Hive 3.x? > > 3. Also can you please suggest best possible work around in such case on > Hive 2.x ? > > On Fri, 7 Sep 2018 05:25 Gopal Vijayaraghavan, <gop...@apache.org> wrote: > >> > msck repair table <table name>; >> >> msck repair does not work on ACID tables. >> >> In Hive 2.x, there is no way to move, replicate or rehydrate ACID tables >> from a cold store - the only way it works if you connect to the old >> metastore. >> >> Cheers, >> Gopal >> >> >>