Load (UDLs)

The COPY statement offers extensive options and settings to control how to load data. However, you may find that these options do not suit the type of data load that you want to perform. The User-Defined Load (UDL) feature lets you develop one or more functions that change how the COPY statement operates. You can create custom libraries using the Vertica SDK to handle various steps in the loading process. The SDK provides APIs for C++ and Java.

You use three types of UDL functions during development, one for each stage of the data-load process:

After the final step, COPY inserts the data into a table, or rejects it, if it is not in the correct format.

In This Section