下载安装包
Sqoop
- 官方地址:http://sqoop.apache.org
- 国内镜像(推荐):http://mirrors.hust.edu.cn/apache/sqoop/1.4.6/
安装Sqoop
下载并解压
```bash下载
[hadoop@iZnm201imn18dkgebcpx40Z ~]$ cd /opt/software [hadoop@iZnm201imn18dkgebcpx40Z software]$ wget http://mirrors.hust.edu.cn/apache/sqoop/1.4.6/解压到/opt/module文件夹
[hadoop@iZnm201qbh8hxwlj3gjqr7Z software]$ tar -zxf sqoop-1.4.6.bin__hadoop-2.0.4-alpha.tar.gz -C /opt/module/
修改文件夹名称
[hadoop@iZnm201qbh8hxwlj3gjqr7Z software]$ cd /opt/module/ [hadoop@iZnm201qbh8hxwlj3gjqr7Z module]$ mv sqoop-1.4.6.bin__hadoop-2.0.4-alpha/ sqoop-1.4.6
<a name="ikDRU"></a>### 配置Sqoop环境变量1. 在/etc/profile.d/my_env.sh文件中添加```bashvim /etc/profile.d/my_env.shexport SQOOP_HOME=/opt/module/sqoop-1.4.6export PATH=$PATH:$SQOOP_HOME/bin
使环境变量生效
source /etc/profile.d/my_env.sh
Sqoop配置
修改配置文件
进入/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
2. 拷贝JDBC驱动,后续读写MySQL数据需要```bash[hadoop@iZnm201qbh8hxwlj3gjqr7Z conf]$ cp /opt/software/6.Mysql/mysql-connector-java-5.1.27-bin.jar /opt/module/sqoop-1.4.6/lib/
- 测试sqoop
[hadoop@iZnm201qbh8hxwlj3gjqr7Z sqoop-1.4.6]$ sqoop help
