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

In This Section