功能描述
向含有自增列的表中加载数据,
需使用table fields 指定列方式进行数据加载,不允
许指定自增列。
示例
CREATE TABLE lineitem
(
a int auto_increment primary key,
L_ORDERKEY
INT NOT NULL,
L_PARTKEY
INTEGER NOT NULL,
L_SUPPKEY
INTEGER NOT NULL,
L_LINENUMBER
INTEGER NOT NULL,
L_QUANTITY
DECIMAL(15,2) NOT NULL,
L_EXTENDEDPRICE
DECIMAL(15,2) NOT NULL,
L_DISCOUNT
DECIMAL(15,2) NOT NULL,
L_TAX
DECIMAL(15,2) NOT NULL,
L_RETURNFLAG
CHAR(1) NOT NULL,
L_LINESTATUS
CHAR(1) NOT NULL,
L_SHIPDATE
DATE NOT NULL,
GBase 8a MPP Cluster 产品手册
5 数据库管理指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
1038
L_COMMITDATE
DATE NOT NULL,
L_RECEIPTDATE DATE NOT NULL,
L_SHIPINSTRUCT CHAR(25) NOT NULL,
L_SHIPMODE
CHAR(10) NOT NULL,
L_COMMENT
VARCHAR(44) NOT NULL
);
gbase> LOAD DATA INFILE 'http://192.168.154.99/tpch1s/lineitem.tbl' INTO
TABLE
test.lineitem
FIELDS
terminated
by
'|'
table_fields
'L_ORDERKEY,L_PARTKEY,L_SUPPKEY,L_LINENUMBER,L_QUANTI
TY,L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LIN
ESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINS
TRUCT,L_SHIPMODE,L_COMMENT';
Query OK, 6001215 rows affected (Elapsed: 00:00:07.60)
Task 5250 finished, Loaded 6001215 records, Skipped 0 records
gbase> SELECT count(distinct(a)) from lineitem;
+--------------------+
| count(distinct(a)) |
+--------------------+
|
6001215 |
+--------------------+
1 row in set (Elapsed: 00:00:01.09)