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 set. But data is present on S3 which i am accessing via hive 2.1.1.
set hive.msck.path.validation=ignore; msck repair table <table name>; Let me know if i have missed anything. Regards, Anup Tiwari