Getting Data into Vertica

Vertica provides many ways to read data. You can load data into the database from a variety of sources, optionally transforming it in various ways. You can read data in place in its original format using external tables. You can use streaming, and you can import data from other Vertica databases. See Common Use Cases for an introduction.

Most data-loading operations, including external tables, revolve around the COPY statement, which has many options. This book focuses on COPY-based reads (data load and external tables). Other data-loading options supported by Vertica are described elsewhere:

For information about… See…
Integrations with other sources Integrating with Apache Kafka and Integrating with Apache Spark
Moving data between Vertica databases Copying Data Between Vertica Databases
Batch inserts into existing tables using JDBC or ODBC Batch Inserts Using JDBC Prepared Statements, Using Batch Inserts
Inserting individual rows and queried data into a table INSERT/INSERT…SELECT

In This Section