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 this is happening. I'm only trying to import ~500,000 rows. I've tried creating a --connection-param-file properties file with jdbc.transaction.isolation=TRANSACTION_READ_UNCOMMITTED added, but this seems to have no effect. I've also tried adding -D sqoop.export.records.per.statement=500 to reduce the load on the database, and it does not help either. I've also scaled the Azure Database to the highest Premium level they have, and I can see the CPU/throughput units (DTUs) hitting 65%, but records only get inserted after the job fails. Any help is greatly appreciated!
