Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
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

avatar
Master 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

avatar
Master 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

 

 

avatar
Explorer

@aakulov Thank you for the response. This works.