sqoop-1.4.6安装配置

前沿

centos 7

jdk1.8.0

hadoop-2.7.3

hbase-1.3.1

hive-2.1.1

zookeeper-3.4.9

Mysql-5...

Sqoop-1.4.6

解压

[hadoop@master local]$ tar -zxvf ./app/sqoop-1.4.6.bin__hadoop-2.0.4-alpha.tar.gz -C ./soft/

进入/usr/local/soft/重命名

mv sqoop-1.4.6.bin__hadoop-2.0.4-alpha sqoop-1.4.6

配置环境变量

[hadoop@master local]$ vi ~/.bashrc

export SQOOP_HOME=/usr/local/soft/sqoop-1.4.6
export PATH=$PATH:$SQOOP_HOME/bin

[hadoop@master local]$ source ~/.bashrc

Sqoop配置

sqoop-env.sh配置 

sqoop-env.sh配置文件没有，我们需要将sqoop-env-template.sh复制为sqoop-env.sh，sqoop-env-template.sh在sqoop-1.4.6/conf中

[hadoop@master conf]$ cp sqoop-env-template.sh sqoop-env.sh

[hadoop@master conf]$ vi sqoop-env.sh

#Set path to where bin/hadoop is available
export HADOOP_COMMON_HOME=/usr/local/soft/hadoop-2.7.3

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

#set the path to where bin/hbase is available
export HBASE_HOME=/usr/local/soft/hbase-1.3.1

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

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

configure-sqoop配置 (注释以下内容)

mysql-connector-java放入

将mysql-connector-java-***-bin.jar放入/sqoop-1.4.6/lib/下    下载地址为：https://dev.mysql.com/downloads/connector/j/

测试Sqoop

[hadoop@master bin]$ sqoop version

下面进行简单的测是用sqoop连接Mysql

sqoop list-databases： 查看Mysql中的所有数据库

sqoop list-databases --connect jdbc:mysql://master:3306 --username root --password 123456     //root,123456是我mysql的用户名和密码

至此sqoop-1.4.6的安装完毕！！！