sqoop安装

0.下载sqoop

 使用1.x版本

1.拷贝 MySQL的jdbc驱动包mysql-connector- Java-5.1.31-bin.jar到sqoop/lib目录下。

2.配置环境变量

#sqoop

export SQOOP_HOME=/data/sqoop

export PATH=$PATH:$SQOOP_HOME/bin

3.复制sqoop/conf/sqoop-env-template.sh为sqoop-env.sh

添加相关的配置

#Setpath to where bin/ Hadoop is available

export HADOOP_COMMON_HOME=/data/hadoop

#Setpath to where hadoop-*-core.jar isavailable

export HADOOP_MAPRED_HOME=/data/hadoop

#setthe path to where bin/ Hbase isavailable

export HBASE_HOME=/data/hbase 

#Setthe path to where bin/ Hive is available

export HIVE_HOME=/data/hive

#Setthe path for where zookeper config diris

export ZOOCFGDIR=/data/zookeeper

4.sqoop导数据

1.必须给集群中的其他服务器开通mysql权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.1.6.40' IDENTIFIED BY '123456' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.1.6.42' IDENTIFIED BY '123456' WITH GRANT OPTION;