Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop MS SqlServer Driver Class not found

Sqoop MS SqlServer Driver Class not found

New Contributor

I am brand new to Cloudera and Sqoop.  We are running CDH5.7.2  I have followed the instructions for setting up the Microsoft JDBC driver, by placing the jars in /var/lib/sqoop but when trying to set up a Link in Hue for this drier, it says Class not found.  You can see from the screenshot below.

 

The driver itself works properly from command line like this:

sqoop import 
--query "select * from table where xfield  = yfield  and \$CONDITIONS"
--target-dir "target" 
--driver com.microsoft.sqlserver.jdbc.SQLServerDriver
--connect jdbc:sqlserver://server.com 

 

Thanks in advance for your help.

 

SqoopDriverError.JPG

Don't have an account?
Coming from Hortonworks? Activate your account here