#1、版本支撑
1.4.6|7 => hadoop 2.X + hive 1.X + hbase 1.X
=> hadoop 3.1.3 + hive 3.1.2 + hbase 2.3.5(not support)
#2、操作类型:参考方向为
RDBMS -import -> hadoop(hdfs|hive|hbase) -export -> RDBMS(mysql|oracle|...)
#3、sqoop146安装
#解压和改名
tar -zxvf /opt/download/hadoop/sqoop-1.4.6.bin__hadoop-2.0.4-alpha.tar.gz -C /opt/software/
mv /opt/software/sqoop-1.4.6.bin__hadoop-2.0.4-alpha.tar.gz /opt/software/sqoop146
#修改环境配置
vim /etc/profile.d/myenv.sh
#sqoop
export SQOOP_HOME=/opt/software/sqoop146
export LOGDIR=$SQOOP_HOME/logs
export PATH=$SQOOP_HOME/bin:$PATH
source /etc/profile
vim sqoop-env.sh
export HADOOP_COMMON_HOME=/opt/software/hadoop313
export HADOOP_MAPRED_HOME=/opt/software/hadoop313
export HBASE_HOME=/opt/software/hbase235
export HIVE_HOME=/opt/software/hive312
export ZOOCFGDIR=/opt/software/zookeeper357
#4、测试
mysql -u root 12345678
grant all on *.* to root@'%' identified by 'kb12kb12';
sqoop list-databases --connect jdbc:mysql://singlelucky:3306 --username root --password kb12kb12