Skip to main content
AdityaShaw
AdityaShaw
Gold ⭐️
October 20, 2020
Solved

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

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
aakulovAnswer
Platinum ⭐️
October 22, 2020

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/controlling_trans_isol.html and here: https://www.tutorialspoint.com/java-connection-settransactionisolation-method-with-example

 

Hope this helps.

 

Regards,

Alex

 

 

View in thread

2 replies

aakulov
Platinum ⭐️
aakulovAnswer
Platinum ⭐️
October 22, 2020

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/controlling_trans_isol.html and here: https://www.tutorialspoint.com/java-connection-settransactionisolation-method-with-example

 

Hope this helps.

 

Regards,

Alex

 

 

Translate
AdityaShaw
AdityaShawAuthor
Gold ⭐️
October 29, 2020

@aakulov Thank you for the response. This works.

Translate
Terms & ConditionsAccessibility statement