sqoop找不到MySQL驱动,Sqoop：无法加载mysql驱动程序异常

缺乏、安全感 2022-08-30 11:17 264阅读 0赞

![Image 1][]

I Installed Sqoop in my local machine. Following are the config information.

Bash.bashrc:

export HADOOP\_HOME=/home/hduser/hadoop

export HBASE\_HOME=/home/hduser/hbase

export HIVE\_HOME=/home/hduser/hive

export HCAT\_HOME=/home/hduser/hive/hcatalog

export SQOOP\_HOME=/home/hduser/sqoop

export PATH=$PATH:$HIVE\_HOME/bin

export PATH=$PATH:$HADOOP\_HOME/bin

export PATH=$PATH:$HBASE\_HOME/bin

export PATH=$PATH:$SQOOP\_HOME/bin

export PATH=$PATH:$HCAT\_HOME/bin

Hadoop:

Version: Hadoop 1.0.3

Hive:

Version: hive 0.11.0

Mysql Connector driver

version: mysql-connector-java-5.1.29

"The driver is copied to the lib folder of sqoop"

Sqoop :

version: sqoop 1.4.4

After making all the installation I create a table in mysql named practice\_1, But when I run the load command to load data from mysql to hdfs the command throws an exception:

ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: Could not load db driver class: com.mysql.jdbc.Driver

Coud anyone please guide me what can be the possible problem.

解决方案

You need database driver in 'SQOOP' classpath check this

It has wonderful explanation about the 'SQOOP'

SQOOP has other options like

Ex: --driver com.microsoft.jdbc.sqlserver.SQLServerDriver -libjars=".\*jar"

from here

You can use Sqoop with any other JDBC-compliant database. First, download the appropriate JDBC driver for the type of database you want to import, and install the .jar file in the $SQOOP\_HOME/lib directory on your client machine. (This will be /usr/lib/sqoop/lib if you installed from an RPM or Debian package.) Each driver .jar file also has a specific driver class which defines the entry-point to the driver. For example, MySQL's Connector/J library has a driver class of com.mysql.jdbc.Driver. Refer to your database vendor-specific documentation to determine the main driver class. This class must be provided as an argument to Sqoop with --driver.

You may be interested in understanding the difference between connector and driver here is the article

[Image 1]: