Good morning to all, sorry but i do not speak English very well. i have an error loading a file in teradata with bteq. my file is an extraction from sql server. The data inside my file looks like follows;
Strahge, there can't be a deadlock on a volatile table, because there are no locks on it.
Could you show your actual BTEQ script and/or it's output?
And i noted another problem, you didn't specify a Primary Index, thus it defaults to the first columns, which happens to be a CHAR(1). This table will have a totally skewed distribution, think about a better PI.
i retry to load with the script and the prompt now don't show the error (Failure 2631 Transaction ABORTed due to deadlock.Statement# 1, Info =0) strange but the table are loaded completly thanks a lot for the help