使用Apache Sqoop从MySQL导入数据-错误:没有用于连接字符串的管理器 [英] Data import from MySQL with Apache Sqoop - Error : No manager for connect string
问题描述
我正在尝试将Mahout与外部数据源集成.我正在关注 Apache Mahout Cookbook 这本书.
I'm trying to integrate Mahout with an External Datasource. I'm following the Apache Mahout Cookbook book for that.
我已经配置了Hadoop 2.4,MySQL服务器,并且已经将一个虚拟数据库导入到mysql中.
I have configured Hadoop 2.4, MySQL server and I have imported a dummy database into mysql.
我还按照本书中的步骤安装了Apache Sqoop,并在Sqoop库(sqoop/lib)中下载并部署了mysql-connector-java-5.1.30.jar
I have also installed Apache Sqoop following the steps in the book and I have downloaded and deployed mysql-connector-java-5.1.30.jar in the Sqoop library (sqoop/lib)
我已经用ant命令构建了sqoop:
I've built sqoop with ant command :
ant mvn-install
构建正常.
我正在尝试使用本书中所述的以下命令从mysql导入数据:
I'm trying to import data from mysql using the following command as described in the book :
sqoop import-all-tables --connect jdbc:mysql/localohost/bbdatabank --username root -P --verbose
但是失败,并显示以下错误:
But it's failing with following error :
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/05/05 14:19:29 DEBUG tool.BaseSqoopTool: Enabled debug logging.
Enter password:
14/05/05 14:19:30 DEBUG sqoop.ConnFactory: Loaded manager factory: com.cloudera.sqoop.manager.DefaultManagerFactory
14/05/05 14:19:30 DEBUG sqoop.ConnFactory: Trying ManagerFactory: com.cloudera.sqoop.manager.DefaultManagerFactory
14/05/05 14:19:30 DEBUG manager.DefaultManagerFactory: Trying with scheme: jdbc
14/05/05 14:19:30 ERROR tool.BaseSqoopTool: Got error creating database manager:
java.io.IOException: No manager for connect string: jdbc:mysql/localohost/bbdatabank
at org.apache.sqoop.ConnFactory.getManager(ConnFactory.java:185)
at org.apache.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:225)
at org.apache.sqoop.tool.ImportTool.init(ImportTool.java:84)
at org.apache.sqoop.tool.ImportAllTablesTool.run(ImportAllTablesTool.java:82)
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)
有人可以帮我找到我所缺少的吗?为什么会产生此错误,我该如何解决?
PS::我没有安装HBase或HCatalog,因为这本书说我不需要它.
PS : I haven't installed HBase nor HCatalog cause the book says that I don't need it.
推荐答案
看起来您的jdbc网址不正确,应该像
Looks like your jdbc url is incorrect, it should be like
jdbc:mysql://localhost/bbdatabank
这篇关于使用Apache Sqoop从MySQL导入数据-错误:没有用于连接字符串的管理器的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!