示例
建表语句:
CREATE TABLE t (i INT, vc VARCHAR(10), dt DATETIME
DEFAULT '2000-01-01 00:00:01', dt1 DATETIME DEFAULT
'2000-01-01 00:00:01');
GBase 8a MPP Cluster 产品手册
5 数据库管理指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
1208
数据文件:
31589,E,02:02:02 2094-12-13,2082-12-24 01:01:01
16993,jcWaz,02:02:02 2060-10-22,2037-11-17 01:01:01
7584,jubNKAmT,02:02:02 2058-12-24,2066-11-26 01:01:01
8698,iOStkY,02:02:02 2024-11-17,2064-10-25 01:01:01
23256,itWsHqL,02:02:02 2069-10-24,2021-11-19 01:01:01
21932,GelDJbuE,02:02:02 2017-11-26,2075-11-19 01:01:01
4859,Gl,02:02:02 2040-10-16,2051-10-25 01:01:01
11751,InTUcdIM,02:02:02 2048-12-23,2099-10-26 01:01:01
8487,JZ,02:02:02 2026-12-13,2084-11-15 01:01:01
3693,lEKyI,02:02:02 2063-10-21,2026-11-20 01:01:01
加载过程:
gbase> LOAD DATA INFILE 'ftp://192.168.88.141/load_data/table_fields.tbl'
INTO TABLE test.t fields terminated by ',' TABLE_FIELDS 'i, vc, dt date
"%H:%i:%s %Y-%m-%d", dt1 date "%Y-%m-%d %H:%i:%s"';
Query OK, 10 rows affected, 0 warnings (Elapsed: 00:00:01.48)
Task 1114 finished, Loaded 10 records, Skipped 0 records
查询入库数据:
gbase> SELECT * FROM Test.t;
+-------+----------+---------------------+---------------------+
| i
| vc
| dt
| dt1
|
+-------+----------+---------------------+---------------------+
| 23256 | itWsHqL
| 2069-10-24 02:02:02 | 2021-11-19 01:01:01 |
| 31589 | E
| 2094-12-13 02:02:02 | 2082-12-24 01:01:01 |
|
8487 | JZ
| 2026-12-13 02:02:02 | 2084-11-15 01:01:01 |
| 21932 | GelDJbuE | 2017-11-26 02:02:02 | 2075-11-19 01:01:01 |
| 16993 | jcWaz
| 2060-10-22 02:02:02 | 2037-11-17 01:01:01 |
|
3693 | lEKyI
| 2063-10-21 02:02:02 | 2026-11-20 01:01:01 |
| 11751 | InTUcdIM | 2048-12-23 02:02:02 | 2099-10-26 01:01:01 |
|
8698 | iOStkY
| 2024-11-17 02:02:02 | 2064-10-25 01:01:01 |
|
4859 | Gl
| 2040-10-16 02:02:02 | 2051-10-25 01:01:01 |
|
7584 | jubNKAmT | 2058-12-24 02:02:02 | 2066-11-26 01:01:01 |
+-------+----------+---------------------+---------------------+
10 rows in set