当我尝试运行sqoop命令时,我收到错误,说没有连接字符串的管理器
我尝试运行的内容:
sqoop export --connect "jdbc:vertica://xxxxxxxx.com:5433/PPS_GIIA" --username xxxxx --password
xxxxx --table Country -m 1 --export-dir /Eservices/SIPOC/SQLimport/part-m-0000 --input-
fields- terminated-by ',' --lines-terminated-by '\n'
我得到的错误:
WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P
instead.ERROR tool.BaseSqoopTool: Got error creating database manager: java.io.IOException: No
manager for connect string: jdbc:vertica://xxx:5637/xxx at
org.apache.sqoop.ConnFactory.getManager(ConnFactory.java:185)
我已经复制了Vertica驱动程序并将其放在/sqoop-1.4.3/lib中.有人知道是什么造成的吗?
解决方法:
您在命令行中缺少驱动程序.它应该是以下形式:
--driver <jdbc driver fully qualified class>
--driver com.vertica.jdbc.Driver