sqoop找不到mysql驱动

来源：互联网发布：淘宝平价女装编辑：程序博客网时间：2024/04/28 21:45

[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也没发现有哪些不同，很不解。

0 0