LOAD DATA INFILE for MariaDB Xpand

Overview

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).