question Re: Sqoop import to MS PDW is failing with com.microsoft.sqlserver.jdbc.SQLServerException: Setting IsolationLevel to ReadCommitted is not supported. in Support Questions

Sqoop import to MS PDW is failing with com.microsoft.sqlserver.jdbc.SQLServerException: Setting IsolationLevel to ReadCommitted is not supported.

AdityaShaw — Tue, 20 Oct 2020 15:26:26 GMT

Hi Team,

We are using HDP 2.6.3 and ambari 2.6.0. we are facing issue while using sqoop import to MS Parallel Data Warehouse. As per https://community.cloudera.com/t5/Community-Articles/Sqoop-to-MS-PDW-Parallel-Data-Warehouse-issue/tac-p/304591 issue is fixed in HDP 2.5.5 version and above but we are still seeing the same issue in HDP 2.6.3. Do we have any workaround for this.

Thanks in Advance!

aakulov — Thu, 22 Oct 2020 04:02:11 GMT

Try adding these options in your sqoop command:

--relaxed-isolation --metadata-transaction-isolation-level TRANSACTION_READ_UNCOMMITTED

Hope this helps.

Regards,

Alex

AdityaShaw — Thu, 29 Oct 2020 10:34:53 GMT

@aakulov Thank you for the response. This works.