|
|
|
|
|
|
This task involves using the COPY command and/or the Data Manipulation Language commands INSERT, UPDATE, and DELETE as described in Using Data Manipulation Language.
Vertica recommends that you use a series of COPY commands to load 10k to 100k tuples per transaction. You can load data into the WOS by using COPY without the DIRECT keyword. This reduces disk usage while allowing you to run queries using AT EPOCH LATEST.