Parallel Load Streams

When you have a large amount of data to load, use parallel load streams to distribute the load operations across the cluster. To do this, create threads from multiple nodes that are connected to the Vertica database and load the data. This approach lets you use vsql, ODBC, ADO.NET, or JDBC. You can load server-side files or client-side files using the COPY from LOCAL statement.

Best practices for parallel load streams are:

For additional information, see Using Parallel Load Streams in the Administrator's Guide.