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 > > >
