Vector 6.3 | Load Data with COPY VWLOAD Statement

User Guide > User Guide > Loading Data > Load Data with COPY VWLOAD Statement

Was this helpful?

Load Data with COPY VWLOAD Statement

The COPY...VWLOAD statement copies the contents of a file to a table using the VWLOAD operator. This operation is similar to using vwload -‑cluster on the command line, except that the load can be done within a multi-statement transaction instead of a separate session.

The vwload --cluster option speeds up loading by parallelizing some of the processing steps.

To use this option, multiple input files are required and they must reside on the server, not the client. Parallelization works best when input files have (almost) the same size.

For example, bulk load the data from multiple files into the region table. Columns in the data file are delimited with a vertical bar, records are delimited by a new line, and null values are identified as NULL:

COPY region() VWLOAD FROM 'path/to/data/mytable_1.txt', 'path/to/data/mytable_2.txt' WITH INSERTMODE=BULK, FDELIM='|', RDELIM='\n', NULLVALUE='NULL', WORK_DIR='/home/users/temp'

Last modified date: 12/06/2024