AnsweredAssumed Answered

Migrate MySQL to MAPR Sandbox

Question asked by DUCNGO on Apr 28, 2017
Latest reply on May 1, 2017 by satz

Hi All, 

 

I know there are plenty of manual and help on Sqoop out there, but i couldn't find the right answer -> need your help

I'm running Mapr Sandbox 5.x and managed to install Sqoop and Mysql-connector-java, I also copy the mysql-connect-xxxxx.jar into /var/lib/sqoop, but i still have this issue below

 

[root@maprdemo sqoop]# sqoop import-all-tables --connect jdbd:mysql//104.155.225.53/IFGSAP --username duc.ngo -P
Warning: /opt/mapr/sqoop/sqoop-1.4.6/bin/../../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
17/04/28 11:27:06 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-mapr-1703
Enter password:
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/opt/mapr/lib/slf4j-log4j12-1.7.12.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/opt/mapr/hive/hive-2.1/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
17/04/28 11:27:38 ERROR tool.BaseSqoopTool: Got error creating database manager: java.io.IOException: No manager for connect string: jdbd:mysql//104.155.225.53/IFGSAP
at org.apache.sqoop.ConnFactory.getManager(ConnFactory.java:191)
at org.apache.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:256)
at org.apache.sqoop.tool.ImportTool.init(ImportTool.java:89)
at org.apache.sqoop.tool.ImportAllTablesTool.run(ImportAllTablesTool.java:82)
at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
at org.apache.sqoop.Sqoop.main(Sqoop.java:236)

Outcomes