Transaction
One or more operations that are executed as a unit of work. At the user level, transactions occur in the current session by a user or script running one or more SQL statements. When you commit a transaction, any changes you make to data in tables using INSERT
, DELETE
, UPDATE
, MERGE
, and COPY
during the transaction become permanent. If you roll back the transaction, all changes made to table data are undone.
Vertica supports Atomicity, Consistency, Isolation, and Durability (ACID) for SQL transactions.