It will be hard for us to debug the problem without access to the MS SQL Server
logs, but one wild idea is to decrease number of statements per transaction to
decrease overall transaction size:
sqoop export -D export.statements.per.transaction=1 …
I would start with 1 - if the job succeeds then
Hi,
I'm trying to export about 300 MB of data into SQL Server (hosted in
Microsoft Azure) with --updateMode allowinsert, but am consistently getting
deadlocks at some point in the export.
This eventually causes all attempts to fail, and the job will get back to
0% mapping.
I don't understand why
