配置sqoop

1.上传tar包
sqoop-1.4.6.bin__hadoop-2.0.4-alpha.tar.gz

2.解压tar包

tar -zxvf sqoop-1.4.6.bin__hadoop-2.0.4-alpha.tar.gz

3.修改文件名

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

4.配置环境变量
进入/etc/profile

vim /etc/profile

添加以下内容

#SQOOP_HOME
export SQOOP_HOME=/opt/sqoop-1.4.6
export PATH=$PATH:$SQOOP_HOME/bin

使配置环境生效

source /etc/profile

查看是否配置成功

sqoop version

5.进入sqoop的conf文件

cd sqoop-1.4.6/conf

6.修改配置文件

复制sqoop-env-template.sh为sqoop-env.sh

cp sqoop-env-template.sh sqoop-env.sh

vim sqoop-env.sh

添加以下内容

export HADOOP_COMMON_HOME=/opt/hadoop-2.7.2
export HADOOP_MAPRED_HOME=/opt/hadoop-2.7.2
export HIVE_HOME=/opt/hive-2.3.7
export ZOOKEEPER_HOME=/opt/zookeeper-3.4.13
export ZOOCFGDIR=/opt/zookeeper-3.4.13
export HBASE_HOME=/opt/hbase-2.2.2

7.拷贝JDBC驱动
拷贝jdbc驱动到sqoop的lib目录下

cp /opt/mysql-libs/mysql-connector-java-5.1.27/mysql-connector-java-5.1.27-bin.jar /opt/sqoop-1.4.6/lib/

8.验证Sqoop

bin/sqoop help

7.测试Sqoop是否能够成功连接数据库

bin/sqoop list-databases --connect jdbc:mysql://node1:3306/ --username root --password 123456

出现以下数据库

information_schema
hive
mysql
performance_schema
test

------安--装--成--功---------