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 stored on the host or client. COPY supports numerous options, including:

• Incoming data format
• Metadata about the data load
• The best parser to use for different types of data
• Parallel load streams to load data
• Data transforms as COPY loads data
• Saving rejected data from parse errors to files or a table