Support Questions

Find answers, ask questions, and share your expertise

Performance issues during the ACID transactions.

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 ?


Expert Contributor

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