Hello, I'm working on migrating my Hive Setup from Hive 3 to Hive 4 in which I'm facing a few issues especially with ACID tables like 1. Being not able to read data inserted via Hive 3 from Hive4 and vice versa for transactional tables. 2. Unable to trigger major Compaction from Hive3(getting stuck)
P:S - I have a setup where I have some of my clusters using Hive3 and some of them being upgraded to Hive4 using a common metastore with Hive4 schema.Also I have made some metastore schema changes already to support Hive4 schema from Hive3. And for the time being I want this setup to work seamlessly as migrating all of the clusters to Hive4 would take some considerable time. Therefore I wanted to check if this behaviour is expected (for ACID tables) and if there is a blog/document like Migrating Hive 1-2 to Hive 3 <https://docs.cloudera.com/cdp-private-cloud-upgrade/latest/upgrade-cdh/topics/ug_cdh_hive_preupgrade_tasks.html> which suggests proper steps for upgrading Hive schema and migrating data from Hive 3 to Hive4. Thanks for your help. Regards, Ratnesh
