Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Do i have to commit my insert statment in hive ?

Solved Go to solution
Highlighted

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

Accepted Solutions

Re: Do i have to commit my insert statment in hive ?

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.

1 REPLY 1

Re: Do i have to commit my insert statment in hive ?

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.

Don't have an account?
Coming from Hortonworks? Activate your account here