mysql - sqoop连接mysql出错

Question

我已经下载了连接器并将 jar 文件保存在 sqoop/lib 文件夹下，即使这样我也遇到了这个问题。

at@ubuntu:~$ sqoop list-databases --connect "jdbc:mysql://localhost" --username root --password root Warning: /usr/lib/hcatalog does not exist! HCatalog jobs will fail. Please set $HCAT_HOME to the root of your HCatalog installation. 14/01/08 16:20:45 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 14/01/08 16:20:45 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset. 14/01/08 16:20:45 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.CatalogQueryManager.listDatabases(CatalogQueryManager.java:57) at org.apache.sqoop.tool.ListDatabasesTool.run(ListDatabasesTool.java:49) at org.apache.sqoop.Sqoop.run(Sqoop.java:145) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) 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)

Answer 1

此错误的原因是sqoop无法连接到指定的mysql驱动

尝试将 mysql jar 放在下面的库中

/opt/cloudera/parcels/CDH/lib/sqoop/lib//opt/cloudera/parcels/CDH-1.5.0-1../lib/sqoop/lib//var/lib/sqoop/

然后重启一次集群，运行sqoop命令即可。

谢谢。