Support Questions
Find answers, ask questions, and share your expertise

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

Explorer

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!

1 ACCEPTED SOLUTION

Super Collaborator

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

 

 

View solution in original post

2 REPLIES 2

Super Collaborator

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

 

 

Explorer

@aakulov Thank you for the response. This works.

; ;