Search code examples
mysqlsqoop

Sqoop exec job - : java.lang.ClassNotFoundException: com.mysql..jdbc.Driver

sqoop executive the job:sqoop job --skip-dist-cache --exec sqoop_full_bi_fact_autoloan_contract The following error: enter image description here

and sqoop libs like : enter image description here

So， why does the sqoop job fail

Solution

  • 1- go to this website : https://ftp.jaist.ac.jp/pub/mysql/Downloads/Connector-J/

    2- download a version of the connector (5.1.49.tar.gz is working fine for me)

    3- extract the tar file using command : tar -zxf mysql-connector-java-5.1.49.tar.gz

    4- put the extracted jar file in SQOOP_HOME/lib (SQOOP_HOME is where you have installed sqoop)