For compatibility purposes, Xpand supports LOAD DATA INFILE to load data. However, this is the least performant way to load data onto Xpand. 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.
- Xpand requires that TERMINATED BY be specified before STARTING BY.
Unsupported for LOAD DATA INFILE
- Xpand does not support empty string for FIELDS TERMINATED BY or FIELDS ENCLOSED BY (or fixed row formats).