Reason: actual column number in csv file is less than schema column number.actual number 1

使用 doris 本地导入数据失败

导入语句是

curl --location-trusted -u root  -H "lable:112"  -T testData.csv http://192.168.10.111:8040/api/example_db/example_range_tbl/_stream_load

用浏览器打开错误的url，查看详细信息

报错： actual column number in csv file is less than schema column number.actual number 1

字面意思：导入文件的列数小于表的列数，实际只有 1 列

原因：导入时，未指定列的分割符，导致一行数据被解析为 1列

解决方案：加入分隔符条件 “ -H "column_separator:|" ”

curl --location-trusted -u root  -H "lable:112" -H "column_separator:|" -T testData.csv http://192.168.10.111:8040/api/example_db/example_range_tbl/_stream_load