Bulk-Loading Data

This section describes different methods to bulk-load data into a Vertica database using the COPY statement. In its simplest form, COPY copies data from a source to a file, as follows:

COPY target-table FROM data-source 

Source data can be a data stream or a file path. You can specify many details about a data load, including:

• Data format and compression
• Which built-in parser to use, or which user-defined source, filters, or parser to use
• How to distribute the data load among database nodes
• How to transform data during loading
• What to do with data that could not be loaded