前沿
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的安装完毕!!!