kes-sys_bulkload 工具快速加载数据

sys_bulkload 是 KingbaseES 提供的快速加载数据的命令行工具，该工具能够把一定格式的文本数据简单、快速的加载到 KingbaseES 数据库中。
创建导入数据表

create TABLE test(id int primary key, info text, crt_time timestamp);

数据文件示例：将下列数据以 test.csv 为文件名保存到 KingbaseES 服务器所在目录

1,29b35ff06c949e7e442c929e1df86396,2017-10-08 10:52:47.746062
2,06fde814525395de5ab85f6d92b04e87,2017-10-08 10:52:47.746573
3,c93f02e8677c9cd7c906c6ad5dbd450e,2017-10-08 10:52:47.746627
4,6541700070ae3d051f965fcef43baf45,2017-10-08 10:52:47.746835
5,3d7e7246016acaa842526b6614d0edf5,2017-10-08 10:52:47.746869
6,1d1ae5a03ef0bad3bc14cd5449ba0985,2017-10-08 10:52:47.746894
7,7745c57c54b97656bec80a502ec13ec7,2017-10-08 10:52:47.746918
8,3c377131f6ef82c3284dc77a3b4ffdf7,2017-10-08 10:52:47.746942
9,5ef98d40aeeadf65eb1f0d7fd86ed585,2017-10-08 10:52:47.746968
10,312c0a0188da9e34fe45aa19d0d07427,2017-10-08 10:52:47.746993

导入数据
1，以 BUFFERED 方式导入 TEXT 文件配置文件示例（以 test.ctl 为名保存到服务器所在目录，也可自行指定其他目录。)

TABLE = test
INPUT = /home/kingbase/test.csv
TYPE = CSV
SKIP = 2
LIMIT = 5
WRITER = BUFFERED
PROCESSOR_COUNT = 3

2，使用配置文件导入命令示例

./sys_bulkload -h localhost -p 54321 -d TEST /home/kingbase/test.ctl -U SYSTEM -W 123456

3，使用配置文件导入结果
导入成功提示信息：

NOTICE: BULK LOAD START
NOTICE: BULK LOAD END
2 Rows skipped.
5 Rows successfully loaded.
0 Rows not loaded due to parse errors.
0 Rows not loaded due to duplicate errors.
0 Rows replaced with new rows.
log path: /home/test/test.log
parse error path: /home/test/test.bad
duplicate error path: /home/test/test.dupbad
ctrl file path: /home/test/test.ctl
data file path: /home/test/test.csv
Run began on 2021-03-27 22:53:26.690476+08
Run ended on 2021-03-27 22:53:27.496344+08

导入结果查询（配置指定跳过前 2 行，限制导入条数 5 条）：

test=# select * from test;
id | info | crt_time
----+----------------------------------+----------------------------
3 | c93f02e8677c9cd7c906c6ad5dbd450e | 2017-10-08 10:52:47.746627
4 | 6541700070ae3d051f965fcef43baf45 | 2017-10-08 10:52:47.746835
5 | 3d7e7246016acaa842526b6614d0edf5 | 2017-10-08 10:52:47.746869
6 | 1d1ae5a03ef0bad3bc14cd5449ba0985 | 2017-10-08 10:52:47.746894
7 | 7745c57c54b97656bec80a502ec13ec7 | 2017-10-08 10:52:47.746918
(5 行记录)