Gbase 8a数据加载常见错误

Gbase 8a数据加载常见错误

1.Login denied uri
测试用例：gbase> load data infile ‘ftp://gbase:gbase123@192.168.5.25//home/gbase/1.txt’ into table test.t1 data_format 3;
ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Expanding wildcard operation failed with error - Login denied : ftp://gbase:@ 192.168.5.25//home/gbase/1.txt
错误原因：gbase用户密码错误
2.failed to get table distribution information
测试用例：
gbase> load data infile ‘ftp://gbase:gbase@192.168.5.25//home/gbase/2.txt’ into table test.t2 data_format 3;
ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: failed to get table distribution information.
报错原因：所涉及加载表不存在
3.Could not get file size
测试用例：
gbase> load data infile ‘ftp://gbase:gbase@192.168.5.25//home/gbase/3.txt’ into table test.t3data_format 3;
ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: I/O operation on ftp://gbase:@ 192.168.5.25//home/gbase/3.txt failed with error - 550 Could not get file size., File name ftp://gbase:**@ 192.168.5.25//home/gbase/3.txt

错误原因：/home/gbase/4.txt 这个文件不存在
4.Remote file not found uri
测试用例：
gbase> load data infile ‘ftp://gbase:gbase@192.168.5.25//home/gbase/*.tbl’ into table test.tt data_format 3;
ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Expanding wildcard operation failed with error - Remote file not found uri : ftp://gbase:*****@ 192.168.5.25//home/gbase/%2a.tbl.

错误原因：/home/gbase/*.tbl 没有匹配到文件，通配符文件不存在
5.Too many bad records
测试用例：
load data infile ‘ftp://gbase:gbase@192.168.5.25//home/gbase/2.txt’
into table test.t4 data_format 3 max_bad_records 0;
ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Task 262162 failed, 192.168.5.25:5050Failed to query in gnode:
DETAIL: (GBA-01-600) Gbase internal error: Task 262162, Too many bad records!

错误原因：错误数据行数超过max_bad_records指定值

6. Timeout was reached
   错误原因：ftp服务器端超时
7. Line length is more than gbase_loader_max_line_length
   测试用例:
   gbase> load data infile ‘ftp://gbase:gbase@192.168.5.25//home/gbase/len.txt’ into table test.length data_format 3;
   ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Task 393223 failed, 192.168.5.25:5050Failed 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:*****@ 192.168.5.25//home/gbase/len.txt’
   错误原因：行长度超过参数gbase_loader_max_line_length值。
8. Access denied to remote resource
   测试用例：
   gbase> load data infile ‘ftp://gbase:gbase@192.168.5.25/home/gbase/test/2.txt’ into table test.t2 data_format 3 max_bad_records 0;
   ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: I/O operation on ftp://gbase:@ 192.168.5.25/home/gbase/test/2.txt failed with error - Access denied to remote resource, File name ftp://gbase:@ 192.168.5.25/home/gbase/2.txt

错误原因：/home/gbase/test/2.txt路径错误
9 .text parser error
错误原因：表列数与文件列数不一致，文件列数多于表列数
10. data column size less than defined size
错误原因：文件列数少于表的列数