Versions Compared

Key

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

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.

Anchor
unsupported
unsupported
Unsupported for LOAD DATA INFILE

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