Hi, I am running this command to import table from PostgreSQL to hadoop ( from from another machine on same network) sqoop import --connect jdbc:PostgreSQL9.1://159.224.135.117/Demo --table Class -username ykumar60 --password abc@123 --target-dir /HADOOP/hadoop-0.20.2
And it fails and shows this error ERROR tool.BaseSqoopTool: Got error creating database manager: java.io.IOException: No manager for connect string: jdbc:PostgreSQL9.1://169.254.145.119/Demo at org.apache.sqoop.ConnFactory.getManager(ConnFactory.java:119) at org.apache.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:202) at org.apache.sqoop.tool.ImportTool.init(ImportTool.java:83) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:441) 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) at com.cloudera.sqoop.Sqoop.main(Sqoop.java:57) Please help Regards,Yogesh Kumar
