1. 下载链接
http://mirrors.shuosc.org/apache/sqoop/1.4.6/sqoop-1.4.6.bin__hadoop-2.0.4-alpha.tar.gz
2. 创建工作目录,解压sqoop安装包
$ mkdir -p /apps/svr/sqoop
$ tar xzf ~/tools/sqoop/sqoop-1.4.6.bin__hadoop-2.0.4-alpha.tar.gz -C /apps/svr/sqoop/
$ cd /apps/svr/sqoop/
$ mv sqoop-1.4.6.bin__hadoop-2.0.4-alpha/ sqoop-1.4.6.bin/
$ cd sqoop-1.4.6.bin/
3. 配置sqoop环境变量
- $ vim ~/.bash_profile
# SQOOP_HOME
export SQOOP_HOME=/apps/svr/sqoop/sqoop-1.4.6.bin
export PATH=$PATH:$SQOOP_HOME/bin
- $ source ~/.bash_profile
4. 配置 sqoop-env.sh
- $ cd /apps/svr/sqoop/sqoop-1.4.6.bin/conf
- $ cp sqoop-env-template.sh sqoop-env.sh
- $ vim sqoop-env.sh
export HADOOP_COMMON_HOME=/apps/svr/hadoop/hadoop-2.7.3
export HADOOP_MAPRED_HOME=/apps/svr/hadoop/hadoop-2.7.3
export HIVE_HOME=/apps/svr/hive/apache-hive-2.1.1-bin
5. 拷贝mysql驱动
$ cd /apps/svr/sqoop/sqoop-1.4.6.bin/
$ cp ~/jar/mysql-connector-java-5.1.37-bin.jar lib/
6. 测试
$ sqoop list-databases --connect jdbc:mysql://192.168.9.87:3306 --username root --password mysqlpasswd