外部表external table导入数据报错-26168 .
错误信息如下:
26168: Conversion err: (file,offset,reason,col)=(t.unl,0,TOO_MANY_FLDS,).
我查看了列的数量和文件数量一样,怎么还提示:TOO_MANY_FLDS
收起create table t_akak(c_id integer,c_name varchar(100),c_add varchar(128));
CREATE EXTERNAL TABLE t_akak_ext sameas t_akak
USING (DATAFILES("DISK:/home/informix/data.unl"),
FORMAT 'DELIMITED',
DELIMITER '|' );
INSERT INTO t_akak SELECT * FROM t_akak_ext;
26168: Conversion err:(file,offset,reason,col)=(data.unl,46,INVALID_ROW_SIZE,).
我从windows FTP 到Linux
文件下载如下网盘 data.unl