下载安装包

Sqoop

修改文件夹名称

[hadoop@iZnm201qbh8hxwlj3gjqr7Z software]$ cd /opt/module/ [hadoop@iZnm201qbh8hxwlj3gjqr7Z module]$ mv sqoop-1.4.6.bin__hadoop-2.0.4-alpha/ sqoop-1.4.6

  1. <a name="ikDRU"></a>
  2. ### 配置Sqoop环境变量
  3. 1. 在/etc/profile.d/my_env.sh文件中添加
  4. ```bash
  5. vim /etc/profile.d/my_env.sh
  6. export SQOOP_HOME=/opt/module/sqoop-1.4.6
  7. export PATH=$PATH:$SQOOP_HOME/bin
  1. 使环境变量生效

    1. source /etc/profile.d/my_env.sh

    Sqoop配置

    修改配置文件

  2. 进入/opt/module/sqoop/conf,修改配置文件 ```bash [hadoop@iZnm201qbh8hxwlj3gjqr7Z module]$ cd sqoop-1.4.6/conf/ [hadoop@iZnm201qbh8hxwlj3gjqr7Z conf]$ mv sqoop-env-template.sh sqoop-env.sh [hadoop@iZnm201qbh8hxwlj3gjqr7Z conf]$ vim sqoop-env.sh

export HADOOP_COMMON_HOME=/opt/module/hadoop-3.1.3 export HADOOP_MAPRED_HOME=/opt/module/hadoop-3.1.3 export HIVE_HOME=/opt/module/hive export ZOOKEEPER_HOME=/opt/module/zookeeper-3.5.7 export ZOOCFGDIR=/opt/module/zookeeper-3.5.7/conf

  1. 2. 拷贝JDBC驱动,后续读写MySQL数据需要
  2. ```bash
  3. [hadoop@iZnm201qbh8hxwlj3gjqr7Z conf]$ cp /opt/software/6.Mysql/mysql-connector-java-5.1.27-bin.jar /opt/module/sqoop-1.4.6/lib/
  1. 测试sqoop
    [hadoop@iZnm201qbh8hxwlj3gjqr7Z sqoop-1.4.6]$ sqoop help