sqoop的搭建

1 安装（前提hadoop启动）

[hadoop@h91 ~]$ tar -zxvf sqoop-1.4.6-cdh5.5.2.tar.gz
[hadoop@h91 hadoop-0.20.2-cdh3u5]$ cp hadoop-core-2.6.0-cdh5.5.2.jar /home/hadoop/sqoop-1.4.6-cdh5.5.2/lib/

[hadoop@h91 ~]$ cp ojdbc6.jar sqoop-1.4.6-cdh5.5.2/lib/

[hadoop@h91 ~]$ vi .bash_profile
添加
export SQOOP_HOME=/usr/sqoop-1.4.6-cdh5.5.2

[hadoop@h91 ~]$ source .bash_profile

2.

[hadoop@h91 ~]$ cd sqoop-1.4.6-cdh5.5.2/bin/

[hadoop@h91 bin]$ vi configure-sqoop
注释掉hbase和zookeeper检查
## Moved to be a runtime check in sqoop.
#if [ ! -d "${HBASE_HOME}" ]; then
#  echo "Warning: $HBASE_HOME does not exist! HBase imports will fail."
#  echo 'Please set $HBASE_HOME to the root of your HBase installation.'
#fi


3.mysql 授权

mysql> insert into mysql.user(Host,User,Password) values("hd1","sqoop",password("sqoop"));
mysql> flush privileges;
mysql> grant all privileges on *.* to 'sqoop'@'hd1' identified by 'sqoop' with grant option;
mysql> flush privileges;

mysql> use test;
mysql> create table table_1 (id int,name varchar(10));

mysql> insert into table_1 values(1,'zs');
mysql> insert into table_1 values(2,'ls');




4.测试sqoop能否连接上mysql
[hadoop@h91 mysql-connector-java-5.0.7]$ cp mysql-connector-java-5.6-bin.jar /home/hadoop/sqoop-1.3.0-cdh3u5/lib/

[hadoop@h91 sqoop-1.3.0-cdh3u5]$ bin/sqoop list-tables --connect jdbc:mysql://172.16.1.138:3306/test --username sqoop --password sqoop
（显示有sss表）