Hi sir, Your jdbc path seems incorrect to me as I believe that it should be "jdbc:mysql://10.10.10.10:54310/books" (notice two slashes after "mysql:")
Also did you downloaded and added mysql jdbc connector to sqoop lib directory? You can download it on following link: http://dev.mysql.com/downloads/connector/j/ Jarcec On Thu, Jul 12, 2012 at 06:25:22PM +0530, prabhu k wrote: > Hi user, > > While i am import from mysql db to HDFS, I am getting following error. > > DB name: books > Table name: authors > > > sqoop-1.4.1-incubating__hadoop-0.20# bin/sqoop import --connect jdbc:mysql: > 10.10.10.10:54310/books --username root --table authors --target-dir > /user/root > Warning: /usr/lib/hbase does not exist! HBase imports will fail. > Please set $HBASE_HOME to the root of your HBase installation. > Warning: $HADOOP_HOME is deprecated. > 12/07/12 18:13:34 ERROR tool.BaseSqoopTool: Got error creating database > manager: java.io.IOException: No manager for connect string: jdbc:mysql: > 10.10.10.10:54310/books > 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 suggest me, what i am doing wrong? > > Thanks, > Prabhu.
signature.asc
Description: Digital signature
