【记录】SQOOP 使用过程中遇到的问题

------》HADOOP生态的安装不多做阐述，网上找资料即可

------》SQOOP安装和配置不做阐述

1、sqoop测试时 总是卡在SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]这一步，

仔细一看log：

SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/opt/apps/ecm/service/hadoop/2.7.2-1.3.2/package/hadoop-2.7.2-1.3.2/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/opt/apps/ecm/service/hive/2.3.3-1.0.5/package/apache-hive-2.3.3-1.0.5-bin/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]

两个jar包冲突，删掉其中一个即可，我删掉了$HIVE_HOME/lib/log4j-slf4j-impl-2.6.2.jar这个包 ，顺利解决！

 

2、测试连接mysql数据库时报错如下：

jyy@ubuntu:/usr/local/sqoop/bin$ ./sqoop list-tables --connect jdbc:mysql://localhost：3306/test --username root --password '123456'

20/02/25 17:00:31 INFO ma