在MariaDB列存储数据cpimport中“打开列文件时出错”

Question

我正在尝试将一个大约2 2GB的大文件导入MariaDB Columnstore。其他较小的文件运行良好，所以我怀疑这是一个大小问题。我使用engine Columnstore创建了这个表，没有任何问题。然后我运行以下命令：

sudo cpimport -s '|' -E '"' industry  fdic_callr_rcr_regulat_capital fdic_callr_rcr_regulat_capital.csv

我得到了：

Using table OID 20208 as the default JOB ID
Input file(s) will be read from : /home/sofuser/data/callr
Job description file : /var/lib/columnstore/data/bulk/tmpjob/20208_D20210617_T180941_S792633_Job_20208.xml
Log file for this job: /var/lib/columnstore/data/bulk/log/Job_20208.log
2021-06-17 18:09:42 (2870) INFO : successfully loaded job file /var/lib/columnstore/data/bulk/tmpjob/20208_D20210617_T180941_S792633_Job_20208.xml
2021-06-17 18:09:42 (2870) INFO : Job file loaded, run time for this step : 0.40599 seconds
2021-06-17 18:09:42 (2870) INFO : PreProcessing check starts
2021-06-17 18:09:42 (2870) INFO : input data file /home/sofuser/data/callr/fdic_callr_rcr_regulat_capital.csv
2021-06-17 18:09:50 (2870) ERR  : Error opening column file for OID-21217; DBRoot-1; partition-0; segment-0; filename-/var/lib/columnstore/data1/000.dir/000.dir/082.dir/225.dir/000.dir/FILE000.cdf;  opening a column file. The file was not found or was inaccessible. [1052]
2021-06-17 18:09:50 (2870) CRIT : Error in pre-processing the job file for table industry.fdic_callr_rcr_regulat_capital [1052]
2021-06-17 18:09:50 (2870) ERR  : Error deleting meta file; Error deleting bulk rollback data subdirectory /var/lib/columnstore/data1/bulkRollback/20208_data; [1053]

注意:未找到的文件不是输入文件，而是MariaDB数据库结构中的文件。

This is the log

Answer 1