ARTICLE DETAIL

建站实战干货

来自一线的建站与推广经验沉淀,每一条都经过真实交付验证。

linux安装sqoop

2026/8/24 4:03:28 拓冰建站 浏览量
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. 环境变量
echo 'export SQOOP_HOME=/opt/sqoop/' >> /etc/profile
echo 'export PATH=$PATH:$SQOOP_HOME/bin' >> /etc/profile
source /etc/profile    
  1. sqoop-env.sh
    照着/etc/profile 写好对应路径
    在这里插入图片描述

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

cp /opt/mysql/mysql-connector-java-5.1.49.jar /opt/sqoop/lib
  1. 测试
systemctl status mysqld
sqoop list-databases --connect jdbc:mysql://主机IP:3306/ --username root --P

每次都是连数据库报错:

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驱动解决