Data Loading

The SQL Data Manipulation Language (DML) commands INSERT, UPDATE, and DELETE perform the same functions in Vertica as they do in row-oriented databases. These commands follow the SQL-92 transaction model and can be intermixed.

Use the COPY statement for bulk loading data. COPY reads data from text files or data pipes and inserts it into WOS (memory) or directly into the ROS (disk). COPY can load compressed formats such as GZIP and LZO. COPY automatically commits itself and any current transaction but is not atomic; some rows could be rejected. Note that COPY does not automatically commit when copying data into temporary tables.

You can use the COPY statement's NO COMMIT option to prevent COPY from committing a transaction when it finishes copying data. This allows you to ensure the data in the bulk load is either committed or rolled back at the same time. Also, combining multiple smaller data loads into a single transaction allows Vertica to load the data more efficiently. See the COPY statement in the SQL Reference Manual for more information.

You can use multiple, simultaneous database connections to load and/or modify data.

For more information about bulk loading, see Bulk Loading Data.