GBase南大通用-数据加载常见错误 gbase load data

-----GBase南大通用-----

数据加载常见错误

1.1Login denied uri

测试用例：

gbase>load data infile 'ftp://gbase:XXX@IP//home/gbase/1.txt' into table test.ceshi;

ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Expanding wildcard operation failed with error - Login denied uri : ftp://gbase:********@IP//home/gbase/1.txt

错误原因：gbase用户密码错误或者selinux防火墙没关

1.2Couldn't connect to server

测试用例：

gbase> load data infile 'ftp://gbase:XXX@IP//home/gbase/1.txt' into table test.ceshi;

ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: I/O operation on ftp://gbase:*****@IP//home/gbase/1.txt failed with error - Couldn't connect to server, File name ftp://gbase:*****@IP//home/gbase/1.txt

报错原因：ip地址错误或者vsftpd服务没有启动或者网络问题

1.3550 Could not get file size.

测试用例：

gbase> load data infile 'ftp://gbase:gbase@IP//home/gbase/1.txt' into table test.ceshi;

ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: I/O operation on ftp://gbase:*****@IP//home/gbase/1.txt failed with error - 550 Could not get file size., File name ftp://gbase:*****@IP//home/gbase/1.txt

错误原因：/home/gbase/1.txt 这个文件不存在

1.4Remote file not found uri

测试用例：

gbase> load data infile 'ftp://gbase:XXX@IP//home/gbase/*.txt' into table test.ceshi;

ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Expanding wildcard operation failed with error - Remote file not found uri :ftp://gbase:*****@IP//home/gbase/*.txt.

错误原因：/home/gbase/*.tbl 没有匹配到文件，通配符文件不存在

1.5Access denied to remote resource

测试用例：

gbase> load data infile 'ftp://gbase:XXX@IP/home/gbase/1.txt' into table test.ceshi;

ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: I/O operation on ftp://gbase:*****@IP/home/gbase/1.txt failed with error - Access denied to remote resource, File name ftp://gbase:*****@IP/home/gbase/1.txt

错误原因：/home/gbase/1.txt路径错误或对文件没权限

1.6Too many bad records

测试用例：

load data infile 'ftp://gbase:XXX@IP//home/gbase/1.txt' into table test.ceshi max_bad_records 0;

ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Task 262162 failed, [IP:5050](GBA-02AD-0005)Failed to query in gnode:

DETAIL: (GBA-01-600) Gbase internal error: Task 262162, Too many bad records!

错误原因：错误数据行数超过max_bad_records指定值，具体原因通过show load logs taskid查看

1.7Unsupport local file for loader

测试用例：

gbase> load data infile '//home/gbase/1.txt' into table test.ceshi;

ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Unsupport local file for loader

错误原因：不支持本地文件加载，即file_list参数部分必须填写ip地址和登录用户信息

1.8Line length is more than gbase_loader_max_line_length

测试用例:

gbase> load data infile 'ftp://gbase:XXX@IP//home/gbase/1.txt' into table test.ceshi;

ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Task 393223 failed, IP:5050](GBA-02AD-0005)Failed to query in gnode:

DETAIL: (GBA-01-600) Gbase internal error: Line length 8388608 is more than gbase_loader_max_line_length ( 4194304 ) in file 'ftp://gbase:*****@IP//home/gbase/1.txt'1024*1024

错误原因：行长度超过参数gbase_loader_max_line_length值。

1.9validate error

错误原因1：字符串加载到数字类型字段

错误原因2：yyyymmdd日期格式数据加载到date字段

错误原因3：由于数据长度过长，定义的类型长度太短

1.10text parser error

错误原因：表列数与文件列数不一致，文件列数多于表列数

1.11data column size less than defined size

错误原因：表列数与文件列数不一致，文件列数少于表列数

-----GBase南大通用-----