Loading and Modifying Data

The SQL data manipulation language (DML) commands INSERT, UPDATE, and DELETE perform the same functions in Vertica that they do in a row-oriented database. They can be intermixed and follow the SQL-92 transaction model.

The COPY command is designed for bulk loading data into a Vertica database. It reads data from a delimited text file and inserts tuples either into the WOS (memory) or directly into the ROS (disk). The COPY command automatically commits itself and any current transaction but is not atomic: some rows may be rejected.

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