Re: Not able to read Hive ACID table data created by Hive 2.1.1 in hive 2.3.3

2018-09-06 Thread Anup Tiwari
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

Re: Not able to read Hive ACID table data created by Hive 2.1.1 in hive 2.3.3

2018-09-06 Thread Gopal Vijayaraghavan
> msck repair table ; 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

Not able to read Hive ACID table data created by Hive 2.1.1 in hive 2.3.3

2018-09-06 Thread Anup Tiwari
Hi All, I have created an ACID manage table in hive 2.1.1 whose location is S3. Now i am creating same table(same DDL) on hive 2.3.3 which is pointing to same location and successfully executed below 2 commands but post this when i trying to execute sample select statement , i am getting empty

Re: repair partition on hive transactional table is not working

2018-09-06 Thread Anup Tiwari
Hi, I have able to resolve above issue by setting below parameter :- set hive.msck.path.validation=ignore; Regards, Anup Tiwari On Thu, Sep 6, 2018 at 3:48 PM Anup Tiwari wrote: > Hi All, > > Can anyone look into it? > > On Wed, 5 Sep 2018 19:28 Anup Tiwari, wrote: > >> Hi All, >> >> I

Re: repair partition on hive transactional table is not working

2018-09-06 Thread Anup Tiwari
Hi All, Can anyone look into it? On Wed, 5 Sep 2018 19:28 Anup Tiwari, wrote: > Hi All, > > I have executed "msck repair table " on my hive ACID table and > it printed message that partitions added but when i am querying it; it is > giving below error :- > > > > Vertex failed, vertexName=Map