1)上传
2)解压
tar -xvzf sqoop-1.4.6.bin__hadoop-2.0.4-alpha.tar.gz
3)配置环境变量
export SQOOP_HOME=/home/hadoop/apps/sqoop-1.4.6.bin__hadoop-2.0.4-alpha
export PATH=$PATH:$SQOOP_HOME/bin
4)生效环境变量 并验证
source /etc/profile
sqoop version
5)修改配置文件
cp sqoop-env-template.sh sqoop-env.sh
修改配置文件解析:
#Set path to where bin/hadoop is available
export HADOOP_COMMON_HOME=/home/hadoop/apps/hadoop-2.7.6
#Set path to where hadoop-*-core.jar is available
export HADOOP_MAPRED_HOME=/home/hadoop/apps/hadoop-2.7.6
#set the path to where bin/hbase is available
#export HBASE_HOME= hbase的目录
#Set the path to where bin/hive is available
export HIVE_HOME=/home/hadoop/apps/apache-hive-2.3.4-bin
#Set the path for where zookeper config dir is
export ZOOCFGDIR=/home/hadoop/apps/zookeeper-3.4.10/conf
hadoop的common mapreduce为什么需要分开配置:
开源:
hadoop来说 common mapreduce都在一个安装包中 对于开源的来说上面的两个都是hadoop的安装目录
商业版:
CDH HDP
对于商业版本的hadoop来说 common和mapreduce分别安装在不同的目录下的
6)将mysql的驱动放在sqoop的lib包下
/home/hadoop/apps/sqoop-1.4.6.bin__hadoop-2.0.4-alpha/lib
7)测试:
sqoop list-databases \
--connect jdbc:mysql://hadoop02:3306/ \
--username root \
--password 123456