4. Stage 2--Migrate the Schema, Data, and Queries : Loading Data
Share this page                  
Loading Data
VectorH provides a number of methods for loading data into the database:
INSERT is an SQL statement that is typically used for loading small volumes of data into VectorH tables.
COPY is an SQL statement that can read and write file based data. The files can be located on the server or on the client.
vwload is an external utility that can load file based data. As with COPY, files can be located on the client or on the server. The vwload utility also supports a cluster mode option that uses each DataNode, performing the load in a parallel fashion.
You can use SQL for the vwload cluster mode operation with the COPY table() VWLOAD FROM 'file1', 'file2',... syntax.
The ODBC, JDBC, and .NET drivers support the high performance API calls such as addBatch().
The Spark-Vector Connector lets you load data using Apache Spark. For more information on the Spark-Vector Connector, see https://github.com/ActianCorp/spark-vector/tree/master.
For examples of COPY and vwload, see the SQL Language Guide and the User Guide.