Skip to end of metadata
Go to start of metadata

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