linux安装sqoop

下载

1. 本地下载好
2. 上传，解压，重命名，注意路径

tar -zxvf /opt/sqoop/sqoop-1.4.6.tar.gz -C /opt/
mv /opt/sqoop-1.4.6.bin__hadoop-2.0.4-alpha /opt/sqoop
1
2

配置

1. 环境变量

echo 'export SQOOP_HOME=/opt/sqoop/' >> /etc/profile
echo 'export PATH=$PATH:$SQOOP_HOME/bin' >> /etc/profile
source /etc/profile    
1
2
3

2. sqoop-env.sh
   照着/etc/profile 写好对应路径
   

3. 把mysql驱动添加到$SQOOP_HOME/lib下

cp /opt/mysql/mysql-connector-java-5.1.49.jar /opt/sqoop/lib
1

4. 测试

systemctl status mysqld
sqoop list-databases --connect jdbc:mysql://主机IP:3306/ --username root --P
1
2

每次都是连数据库报错：

ERROR manager.CatalogQueryManager: Failed to list databases
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 198 milliseconds ago. The last packet sent successfully to the server was 189 milliseconds ago.
↑ 换了个JDBC驱动解决