Sqoop安装

1.上传Sqoop&mysql驱动

2.解压sqoop

tar -zxvf sqoop-1.4.6.bin__hadoop-2.0.4-alpha.tar.gz -C /usr/local/soft/

3.重命名

mv sqoop-1.4.6.bin__hadoop-2.0.4-alpha sqoop-1.4.6

4.修改配置文件

#切换至/usr/local/soft/sqoop-1.4.6/conf目录
cd /usr/local/soft/sqoop-1.4.6/conf
#复制配置文件并重命名
cp sqoop-env-template.sh sqoop-env.sh

#vim sqoop-env.sh 编辑配置文件，并加入以下内容
export HADOOP_COMMON_HOME=/usr/local/soft/hadoop-2.7.6
export HADOOP_MAPRED_HOME=/usr/local/soft/hadoop-2.7.6/share/hadoop/mapreduce
export HBASE_HOME=/usr/local/soft/hbase-1.4.6
export HIVE_HOME=/usr/local/soft/hive-1.2.1
export ZOOCFGDIR=/usr/local/soft/zookeeper-3.4.6/conf
export ZOOKEEPER_HOME=/usr/local/soft/zookeeper-3.4.6

5.切换至bin目录下

cd ../bin/

vim configure-sqoop
注释以下内容：

6.修改环境变量

vim /etc/profile
#追加以下内容
#sqoop
export SQOOP_HOME=/usr/local/soft/sqoop-1.4.6
export PATH=$SQOOP_HOME/bin:$PATH

#修改完成后刷新
source /etc/profile

7.添加Mysql驱动

cp mysql-connector-java-5.1.49.jar /usr/local/soft/sqoop-1.4.6/lib/

8.测试

sqoop version

#测试mysql连通性
sqoop list-databases -connect jdbc:mysql://master:3306?useSSL=false -username root -password 123456