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

[#1]

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/t... 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!

[#2 · Accepted solution]

Try adding these options in your sqoop command:

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

More info here: https://docs.cloudera.com/HDPDocuments/HDP2/HDP-2.6.3/bk_data-movement-and-integration/content/contr... and here: https://www.tutorialspoint.com/java-connection-settransactionisolation-method-with-example

Hope this helps.

Regards,

Alex

[#3]

@aakulov Thank you for the response. This works.