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
------安--装--成--功---------