Microsoft Azure HDinsight Ambari Sqoop and Postgres

Question

尝试将数据从Microsoft Azure Hdinsigt上的HDF导入HDF。现在，我从一个非常简单的命令开始，如果列出DBS

sqoop list-databases --connect jdbc.postgresql://xx.xxx.xxx.xxx:yyyy --username myuser --password mypassword

我得到以下错误

ERROR tool.BaseSqoopTool: Got error creating database manager: java.io.IOException: No manager for connect string: jdbc.postgresql://52.178.204.150:4321
    at org.apache.sqoop.ConnFactory.getManager(ConnFactory.java:191)
    at org.apache.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:257)
    at org.apache.sqoop.tool.ListDatabasesTool.run(ListDatabasesTool.java:44)
    at org.apache.sqoop.Sqoop.run(Sqoop.java:148)
    at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
    at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:184)
    at org.apache.sqoop.Sqoop.runTool(Sqoop.java:226)
    at org.apache.sqoop.Sqoop.runTool(Sqoop.java:235)
    at org.apache.sqoop.Sqoop.main(Sqoop.java:244)

我尝试添加以下args

--libjars=/usr/share/java/postgresql-jdbc4.jar
--driver org.postgresql.Driver 
--connection-manager org.apache.sqoop.manager.GenericJdbcManager

这些仍然没有帮助Hdinsight手册仅给出使用Microsoft SQL的示例。

Answer 1

您的连接字符串是错误的：jdbc.应该是jdbc: