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 ?

1 REPLY 1

Re: Performance issues during the ACID transactions.

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

https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-Configuration