Depending on the size of the data, you should select one of the following load methods with the COPY command:
|
Load methods |
Description and use |
|---|---|
|
AUTO |
This is the default option. It loads data into WOS. After WOS is full, it continues loading data into ROS. It is good for data less than 100 MB in size. (Please refer to Chapter 5, Performance Improveme nt, to understand more on ROS and WOS.) |
|
DIRECT |
This loads data directly into ROS containers. It is advised to use the |
|
TRICKLE |
This loads data only into WOS. After WOS is full, it generates an error. It is suggested to use this for frequent incremental load operations. |
An example of a load method is as follows:
COPY table1 from '/root/data/tab1.txt' DIRECT
For incremental loads, it is suggested to use the NO COMMIT command and use the COMMIT command at a later stage for better control at the transaction level.