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 ;
 
05-08 14:52