- 论坛徽章:
- 0
|
大家好。
我也踫到類似的問題,我的操作系統環境是AIX,執行load table時提示如下錯誤:
Msg 21, Level 14, State 0:
ASA Error -1013027: Number of bytes (2) for a column from an input file has
exceeded the maximum allowed (32767).
-- (db_RecScanner.cxx 725)
load table语句如下:
load table smmc_olapuser.nti_cdr_20110201
(
nti_code '|',
msgid '|',
src_locate '|',
dst_locate '|',
smcid '|',
src '|',
dst '|',
state '|',
deviceno '|',
recv_time '|',
done_time '|',
coding '|',
content '|',
src_type '|',
dst_type '|',
delivery_time '|',
expire_time '|',
alarm_type '|',
alarm_time '|',
alarm_resp '|',
during '|',
flag '\n' --(或'\0a')
)
from '/opt/smmc/data1/nti_cdr_20110201.bcp'
escapes off
quotes off
notify 1000000
with checkpoint on
后用“>”取nti_cdr_20110201.bcp的前10行,执行时却无报错,但在nti_cdr_20110201表里仍查不到相关记录,不知道是啥原因。 |
|