Got error creating database manager: java.io.IOException:

Hello all,

Not sure what mistake I’m doing here. can you please let me know why I can’t get pass this error while doing swoop import to hive table. Thanks

[bbastola@gw01 ~]$ sqoop import --connect “jdbc:mysql//nn01.itversity.com:3306/retail_db” --username retail_dba --password itversity --table departments --hive-home /apps/hive/warehouse --hive-import --hive-table departments --create-hive-table
Warning: /usr/hdp/2.5.0.0-1245/accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
17/01/18 19:10:45 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.5.0.0-1245
17/01/18 19:10:45 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
17/01/18 19:10:45 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override
17/01/18 19:10:45 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
17/01/18 19:10:45 ERROR tool.BaseSqoopTool: Got error creating database manager: java.io.IOException: No manager for connect string: jdbc:mysql//nn01.itversity.com/retail_db
at org.apache.sqoop.ConnFactory.getManager(ConnFactory.java:191)
at org.apache.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:264)
at org.apache.sqoop.tool.ImportTool.init(ImportTool.java:89)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:603)
at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:225)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
at org.apache.sqoop.Sqoop.main(Sqoop.java:243)

At first point the connect string had syntax error- missing ":"
This should be : "jdbc:mysql://nn01.itversity.com:3306/retail_db"
instead of "“jdbc:mysql//nn01.itversity.com:3306/retail_db”

1 Like

Thank you ramesh.devarakonda.