1.1 COPY Statement Introduction

Introduction:

COPY Statement in Vertica is used to perform "Bulk Loading".

The COPY statement loads data from a file stored on the host or client (or in a data stream) into a database table.

We can pass several parameters to COPY statement to define various options such as :

• The format of the incoming data

• Metadata about the data load

• Which parser COPY should use

• Load data over parallel load streams

• How to transform data as it is loaded

• How to handle errors