sqoop找不到mysql驱动

最新推荐文章于 2024-05-28 21:12:27 发布

smallboy2011

最新推荐文章于 2024-05-28 21:12:27 发布

阅读量4.7k

点赞数

CC 4.0 BY-SA版权

分类专栏： hadoop

本文链接：https://blog.youkuaiyun.com/smallboy2011/article/details/38544567

hadoop 专栏收录该内容

10 篇文章

订阅专栏

在尝试使用 Sqoop 1.4.4 版本与 MySQL 5.6 数据库进行数据迁移时，遇到找不到MySQL驱动的问题。尽管已将对应的5.1版驱动放入了Sqoop的lib目录，错误依然存在。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[hadoop2@slave02 ~]$ sqoop import --connect jdbc:mysql://slave02/hadoopguide --table widgets -m 1
Warning: /usr/lib/hbase does not exist! HBase imports will fail.
Please set $HBASE_HOME to the root of your HBase installation.
Warning: /usr/lib/hcatalog does not exist! HCatalog jobs will fail.
Please set $HCAT_HOME to the root of your HCatalog installation.
14/08/13 22:31:32 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
14/08/13 22:31:32 INFO tool.CodeGenTool: Beginning code generation
14/08/13 22:31:33 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: Could not load db driver class: com.mysql.jdbc.Driver
java.lang.RuntimeException: Could not load db driver class: com.mysql.jdbc.Driver
   at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:772)
   at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
   at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:660)
   at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:683)
   at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:240)
   at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:223)
   at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:347)
   at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1277)
   at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1089)
   at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96)
   at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:396)
   at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:502)
   at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
   at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
   at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
   at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
   at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
   at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
[hadoop2@slave02 ~]$

mysql使用的是5.6.sqoop使用的是1.4.4.mysql驱动使用的是5.1，并且mysql驱动已经复制到了sqoop的lib目录下了。

还是出错！！

我使用的是一个新解压的sqoop，出现的这个问题，后来我换成之前我在伪分布式下使用的sqoop就没有这个问题了。我看了一下两个sqoop也没发现有哪些不同，很不解。