(BigData) Sqoop-1.4.2 入门级教程

Sqoop 主要考察远程连接mysql 数据库并操作

1.解压安装包指定位置 并改名

[root@master software]# tar -zxvf sqoop-1.4.2.bin__hadoop-2.0.0-alpha.tar.gz -C /usr/local/src/ 

[root@master software]# cd /usr/local/src/
[root@master src]# mv sqoop-1.4.2.bin__hadoop-2.0.0-alpha/ sqoop

2.配置环境变量

[root@master src]# vim /root/.bash_profile 

###sqoop
export SQOOP_HOME=/usr/local/src/sqoop
export PATH=$PATH:$SQOOP_HOME/bin

[root@master src]# source /root/.bash_profile 

3.修改配置文件

[root@master src]# cd sqoop/conf/
[root@master conf]# mv sqoop-env-template.sh sqoop-env.sh 
[root@master conf]# vim sqoop-env.sh 

export HADOOP_COMMON_HOME=/usr/local/src/hadoop
export HADOOP_MAPRED_HOME=/usr/local/src/hadoop

export HIVE_HOME=/usr/local/src/hive

export ZOOCFGDIR=/usr/local/src/zookeeper
export ZOOKEEPER_HOME=/usr/local/src/zookeeper

4.拷贝Mysql 驱动

[root@master conf]# cp /opt/software/mysql-connector-java-5.1.38.jar /usr/local/src/sqoop/lib/

5.验证Sqoop是否配置成功

[root@master conf]# sqoop-list-databases --connect jdbc:mysql://master:3306 --username root --password Dashuju@06.

Sqoop 配置完成