Clever Geek Handbook

Hadoop: failed to create database manager

when i tried to run sqoop commmand i get an error saying there is no manager to connect the string

What I am trying to run:

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'

The error I am getting:

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)

I already copied the Vertica driver and placed it in / sqoop -1.4.3 / lib. Does anyone have an idea what caused this?

+3


source to share


1 answer


There is no driver on the command line. It should look like:



--driver <jdbc driver fully qualified class>
--driver com.vertica.jdbc.Driver
+5


source






More articles:


All Articles