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).
  • No labels