https://community.cloudera.com/t5/Archives-of-Support-Questions/Do-i-have-to-commit-my-insert-statment-in-hive/m-p/226817#M75198 <P>Hi <A rel="user" href="https://community.cloudera.com/users/69328/sunildirasanchu.html" nodeid="69328">@Data Stocker</A>, 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. </P> Fri, 02 Mar 2018 04:13:00 GMT SQLShaw 2018-03-02T04:13:00Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Do-i-have-to-commit-my-insert-statment-in-hive/m-p/226816#M75197 <P>I have an insert statement on a table, do i have to commit after each DML transaction? </P> Fri, 16 Sep 2022 12:55:18 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Do-i-have-to-commit-my-insert-statment-in-hive/m-p/226816#M75197 Sunildirasanchu 2022-09-16T12:55:18Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Do-i-have-to-commit-my-insert-statment-in-hive/m-p/226817#M75198 <P>Hi <A rel="user" href="https://community.cloudera.com/users/69328/sunildirasanchu.html" nodeid="69328">@Data Stocker</A>, 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. </P> Fri, 02 Mar 2018 04:13:00 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Do-i-have-to-commit-my-insert-statment-in-hive/m-p/226817#M75198 SQLShaw 2018-03-02T04:13:00Z