patternMinor
Is Vertica's COPY atomic?
Viewed 0 times
atomicverticacopy
Problem
Seems like a simple thing, but I can't seem to find it in the docs for
Is Vertica's
COPY.Is Vertica's
COPY atomic? If a data load is interrupted or somehow fails, does Vertica take care of the cleanup?Solution
Vertica supports ANSI SQL-92 isolation levels with standard ACID properties. If a
By default, HP Vertica uses the
The
Documentation
COPY is terminated, interrupted, or an error occurs, it will be rolled back.By default, HP Vertica uses the
READ COMMITTED isolation level.The
COPY command automatically commits itself and any current transaction (except when loading temporary tables). HP recommends that you COMMIT or ROLLBACK the current transaction before you use COPY. Please note that DDL statements are autocommitted.Documentation
Context
StackExchange Database Administrators Q#126284, answer score: 7
Revisions (0)
No revisions yet.