We are facing performance issues during the ACID transactions.
Simple insert,update statements take very longtime to execute. Is it advisable to use ACID transactions in Hive 2.0 ?
Hive ACID transactions are totally advisable.
Please provide what exact performance issue you are facing along with volume of inserts and updates.
Have you tried tuning Hive for ACID transactions like compaction etc.: