Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space ML1 and version 9.2

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.

Anchor
unsupported
unsupported
Unsupported for LOAD DATA INFILE

  • ClustrixDB does not support empty string for FIELDS TERMINATED BY or FIELDS ENCLOSED BY (or fixed row formats).