1. 下载Sqoop
下载链接:sqoop-1.4.7.bin
上传、解压:
2. 配置Sqoop
2.1 配置环境变量
vi /etc/profile
配置如下:
#sqoop
export SQOOP_HOME=/home/hadoop/software/sqoop-1.4.7.bin__hadoop-2.6.0
export PATH=$PATH:$SQOOP_HOME/bin
使环境变量生效:
source /etc/profile
2.2 配置sqoop-env.sh文件
cd /home/hadoop/software/sqoop-1.4.7.bin__hadoop-2.6.0/conf
cp sqoop-env-template.sh sqoop-env.sh
vi sqoop-env.sh
添加如下配置:
export HADOOP_COMMON_HOME=/home/hadoop/software/hadoop-2.6.5
export HADOOP_MAPRED_HOME=/home/hadoop/software/hadoop-2.6.5
export HBASE_HOME=/home/hadoop/software/hbase-1.3.5
2.3 导入jar包
如果需要与MySQL数据库进行交互,需要将MySQL的驱动包mysql-connector-java-5.1.47-bin.jar拷贝至Sqoop安装目录的lib目录下。
cp /home/hadoop/software/mysql-connector-java-5.1.47 mysql-connector-java-5.1.47-bin.jar
3. 测试
输出命令
sqoop version