功能描述 向含有自增列的表中加载数据, 需使用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)