集群配置--sqoop安装配置

一、下载sqoop安装包

http://mirror.bit.edu.cn/apache/sqoop/1.4.7/

二、配置sqoop的sqoop-env.sh

[hadoop@hadoop2 conf]$ mv sqoop-env-template.sh sqoop-env.sh  

vim sqoop-env.sh
#Set path to where bin/hadoop is available
export HADOOP_COMMON_HOME=/usr/local/modules/hadoop-2.7.7

#Set path to where hadoop-*-core.jar is available
export HADOOP_MAPRED_HOME=/usr/local/modules/hadoop-2.7.7

#set the path to where bin/hbase is available
#export HBASE_HOME=

#Set the path to where bin/hive is available
export HIVE_HOME=/usr/local/modules/hive-2.3.4

#Set the path for where zookeper config dir is
export ZOOCFGDIR=/usr/local/modules/zookeeper-3.4.10

三、配置环境变量

vim /etc/profile
export SQOOP_HOME=/usr/local/modules/sqoop-1.4.7
export PATH=$PATH:$JAVA_HOME/bin:$SCALA_HOME/bin:$SQOOP_HOME/bin:$ZOOKEEPER_HOME/bin:$HADOOP_HOME/bin:$HIVE_HOME/bin:$HADO
OP_HOME/sbin

四、拷贝mysql驱动包

cp /usr/local/modules/hive-2.3.4/lib/mysql-connector-java-5.1.27-bin.jar ./

五、验证sqoop安装成功连接数据库

sqoop list-databases --connect jdbc:mysql://192.168.59.128:3306/ --username root -P