GBase 8a
适配迁移
文章
gbase加载数据报错:The number of data columns is less than the number of
发表于2026-01-22 21:43:4977次浏览9个评论
如果再数据加载过程遇到报错:
sftp://gbase:********@IP//gbase/oraToGbase/data3/BL_CNTR_PACKG.txt|1173943386|225|14|The number of data columns is less than the number of c
olumns defined
需要多增加参数: autofill
load data infile 'sftp://gbase:pwd@ip//gbase/oraToGbase/data3/BL_CNTR_PACKG.txt' into table BL_MAINT.BL_CNTR_PACKG data_format 3 null_value 'nullnull' fields terminated by '@#$' autofill datetime format '%Y-%m-%d %H:%i:%s' date format '%Y-%m-%d' ;
热门帖子
- 12025-12-01浏览数:182762
- 22023-05-09浏览数:25056
- 42023-09-25浏览数:18525
- 52020-05-11浏览数:17528