Support Questions
Find answers, ask questions, and share your expertise

Do i have to commit my insert statment in hive ?

New Contributor

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

1 ACCEPTED SOLUTION

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

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.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.