HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Is Vertica's COPY atomic?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
atomicverticacopy

Problem

Seems like a simple thing, but I can't seem to find it in the docs for 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 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.