Teradata 快速加载列长度溢出

Question

piom GET ROW 错误：60，文本：列长度错误，行 未返回！错误！分隔数据解析错误：列 第 1 列第 2 行中的长度溢出

下面列出了我尝试加载的示例 CSV 文件以及 fld 脚本。

"zip1","zip2"
"00601","00631"
"00601","00641"
"00601","00624"
"00601","00731"
"00601","00656"
"00601","00669"
"00601","00664"
"00601","00698"
"00601","00606"

.sessions 2;
ERRLIMIT 40;
.logmech ldap;
.LOGON dummyip.com / dummyuser,pass;
DATABASE DUMMY_DB;
.set record vartext ",";

DROP TABLE ZIP_DISTANCE;
DROP TABLE ZIP_DISTANCE_ERROR1;
DROP TABLE ZIP_DISTANCE_ERROR2;

CREATE SET TABLE ZIP_DISTANCE
(

zip1 VARCHAR(5),
zip2 VARCHAR(5)
)
PRIMARY INDEX ZIP_DISTANCE(zip1, zip2);

RECORD 2;

DEFINE

zip1 (varchar(5)),
zip2 (varchar(5))

FILE="C:\Users\dummyuser\Downloads\gaz2016zcta5distancemiles.csv";

BEGIN LOADING

ZIP_DISTANCE
errorfiles
ZIP_DISTANCE_ERROR1,
ZIP_DISTANCE_ERROR2

CHECKPOINT 5;

INSERT INTO ZIP_DISTANCE
(
ZIP1,
ZIP2
)
VALUES
(
:zip1,
:zip2
);

END LOADING;

.LOGOFF;