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 - missing driver or something else?

Solved Go to solution

Sqoop - missing driver or something else?

New Contributor

Hi,

my ultimate goal is to get some data from SQL Server and import it to HDFS, after discussions with others they have said I am best extracting the data with Sqoop to AVRO files and then creating a HIVE table based on them.

So to do this I'm starting at the beginnning.

Step 1 getting Sqoop to connect to the table, at this point it doesn't have to do anything with it.

In Step 2 I'll worry about extract it AVRO files

So I put together the following command

sqoop import --connect "jdbc:sqlserver://<SQLSERVER>:1433;database=sandbox;user=hdfsuser;password=hdfspassword" --table policy 

And Scoop goes off to try and do it but then I get the following back

Could not load db driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver java.lang.RuntimeException: Could not load db driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver

Does this mean that I need to install it as detailed here;

http://stackoverflow.com/questions/23096655/sqoop-connecting-to-sql-server

Or am I barking up the wrong tree.

I'm having to do a Hadoop POC all on my own so having you all to bounce my ideas off and get help from is a real plus so thanks for taking the time to read all this and any help would be massively appreciated by me.

Thanks, Nic

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Sqoop - missing driver or something else?

You are correct, you need to first install the SQL server connector.

https://community.hortonworks.com/questions/1941/sqoop-connector-for-microsoft-sql-server.html

You will need to copy it into /usr/hdp/current/sqoop-client/lib/

3 REPLIES 3

Re: Sqoop - missing driver or something else?

You are correct, you need to first install the SQL server connector.

https://community.hortonworks.com/questions/1941/sqoop-connector-for-microsoft-sql-server.html

You will need to copy it into /usr/hdp/current/sqoop-client/lib/

Re: Sqoop - missing driver or something else?

New Contributor

Thanks for confirming that, I'll give it a try on Monday, have a great weekend.

Nic

Highlighted

Re: Sqoop - missing driver or something else?

New Contributor

That did the job for me. Thanks again.

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