Cloudera CDH5 adding mysql drivers to sqoop

I installed a Cloudera hadoop CDH5 cluster ( 4 mchines )  and started to play with it .

However soon i ran into a weird problem. When i tried to import some data from mysql using sqoop i realized that the mysql drivers weren’t installed .

Installation was done using parcels . So i after reading a lot of documentation i realized that the directory where i was supposed to put the mysql jar is:

/opt/cloudera/parcels/CDH-5.0.0-1.cdh5.0.0.p0.47/lib/sqoop2/webapps/sqoop/WEB-INF/lib

I used mysql-connector-java-5.1.30-bin.jar .

If the file is not there … It wont be deployed .

One thought on “Cloudera CDH5 adding mysql drivers to sqoop”

  1. Hi , i am using CDH-5.4.5 with sqoop-1.4.5 and i followed cloudera documentation and your above mentioned steps too, but still i am getting the error as shown below

    ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: 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

    link of cloudera guide:

    (http://www.cloudera.com/content/cloudera/en/documentation/core/latest/topics/cdh_ig_jdbc_driver_install.html)

    thanks in advance

Leave a Reply