For compatibility purposes, ClustrixDB supports LOAD DATA INFILE to load data. However, this is the least performant way to load data onto ClustrixDB. Using clx_import is the recommended method for loading data.
Caveats for LOAD DATA INFILE
- LOAD DATA INFILE does not take advantage of any parallelism for performing the import.
- ClustrixDB requires that TERMINATED BY be specified before STARTING BY.
Unsupported for LOAD DATA INFILE
- ClustrixDB does not support empty string for FIELDS TERMINATED BY or FIELDS ENCLOSED BY (or fixed row formats).