FastLoad错误 — SELECT Failed. 2652,
SELECT * FROM teradata_education. emp_fl; 在做查询时碰到2652错误。 SELECT Failed. 2652: Operation not allowed: Teradata_Education.emp_fl is being loaded. 2652 Operation not allowed: %DBID.%TVMID isbeing Loaded. Explanation: This error occurs only when a user issues a request for a table that is being Fast/MultLoaded. Generated By: AMP Steps. For Whom: End User. Notes: The table does exist, but it is not in a form in which it may be accessed. Remedy: Wait until the Fast/Multi Load is finished, then resubmit the request. 原因: 我们从错误代码里可以看出,可能是因为FastLoad操作还没有完成,或因为FastLoad没有正常结束而导致表不可以查询。 解决办法: 1)查看fastload的log,看哪一步出错。如果是因为errorfiles所指定的error表已经存在,那就删除已经error表重新fastload。或使用其它error表。 2)访问的时候加下locking row for access locking row for access SELECT * FROM teradata_education. emp_fl ;
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。