GBase 8a MPP load data data_format=3 数据与表不一致处理

1）数据列少于表列 ：使用autofill填充
LOAD DATA INFILE ‘ftp://gbase:gbase@192.168.1.5//home/gbase/t1.txt’ INTO TABLE tt.t1 DATA_FORMAT 3 FIELDS autofill TERMINATED BY ‘;’ DATETIME FORMAT ‘%Y%m%d%H%i%s’ ;
2）数据列多于表列：使用TABLE_FIELDS 指定
LOAD DATA INFILE ‘ftp://gbase:gbase@192.168.1.5//home/gbase/t1.txt’ INTO TABLE tt.t1 DATA_FORMAT 3 FIELDS TERMINATED BY ‘;’ TABLE_FIELDS ‘id,name,4’ DATETIME FORMAT ‘%Y%m%d%H%i%s’ ;