Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Do i have to commit my insert statment in hive ?

avatar
New Contributor

I have an insert statement on a table, do i have to commit after each DML transaction?

1 ACCEPTED SOLUTION

avatar

Hi @Data Stocker, the short answer is no. The longer answer is that currently Hive has ACID (transactional) capabilities but no concept like BEGIN...END TRANSACTION. There is work being done to provide this in a future release.

View solution in original post

1 REPLY 1

avatar

Hi @Data Stocker, the short answer is no. The longer answer is that currently Hive has ACID (transactional) capabilities but no concept like BEGIN...END TRANSACTION. There is work being done to provide this in a future release.