示例
建表语句:
CREATE TABLE "t" ("a" varchar(10) DEFAULT NULL, "b" int(11)
DEFAULT NULL, "c" datetime DEFAULT NULL, "d" varchar(10)
DEFAULT NULL, "e" decimal(10,2) DEFAULT NULL );
数据文件:
Hello|01
Good|02
GBase 8a MPP Cluster 产品手册
5 数据库管理指南
文档版本953(2022-09-15)
南大通用数据技术股份有限公司
1206
Better|03
加载过程:
gbase> LOAD DATA INFILE 'http://192.168.6.39/data.tbl' INTO TABLE t
FIELDS TERMINATED BY '|' SET c='2016-06-06
18:08:08',d='default',e=20.6;
Query OK, 3 rows affected
Task 2920 finished, Loaded 3 records, Skipped 0 records
查询入库数据:
gbase> SELECT * FROM t;
+--------+------+---------------------------------+---------+-------+
| a
| b
| c
| d
| e
|
+--------+------+----------------------------------+---------+-------+
| Hello
|
1 | 2016-06-06 18:08:08 | default | 20.60 |
| Good
|
2 | 2016-06-06 18:08:08 | default | 20.60 |
| Better |
3 | 2016-06-06 18:08:08 | default | 20.60 |
+--------+------+------------------------------------+---------+-------+
5rows in set