Oozie cant able to find JDBC drivers in Sqoop

Question

Refrence to the previously asked question Oozie + Sqoop: JDBC Driver Jar Location 1 but not able to find jar in HDFS /user/oozie/share/lib/sqoop location.

I have also tried to put driver jars at my workFlow app Lib. Still Drivers not found error occure.

Are you running hadoop cluster in psuedo mode or distributed mode ? — Mr.Chowdary, Dec 19 '14 at 13:24
copy thse driver jars into that location of hdfs if not present. only then oozie can run sqoop using these jars. oozie will not look up for jars in hadoop home directory. — vivek_nk, Dec 20 '14 at 03:48

score 1 · Accepted Answer · answered Dec 24 '14 at 05:27

1

You need to add all lib files like jdbc drivers, etc in the oozie share lib folder inside sqoop folder .

This should resolve your issue.

To check the library files invoked/used by the job , go to the job tracker for the corresponding job and in syslogs you will see which all jars has been used.

answered Dec 24 '14 at 05:27

K S Nidhin

2,622
2
22
44

by adding jdbc driver jars in the workflow lib it is working fine. – Suet Dec 24 '14 at 08:57

score 0 · Answer 2 · answered Dec 24 '14 at 09:05

The exact problem was the single coats "'". Because of single coats oozie take it as a single string. But it was working fine when I was using it in the Sqoop command.

................. --driver com.microsoft.sqlserver.jdbc.SQLServer...................

instead of.

.................. --driver 'com.microsoft.sqlserver.jdbc.SQLServer'................

Oozie cant able to find JDBC drivers in Sqoop

2 Answers2