sqoop
1. 解压 tar -zxvf sqoop-1.99.7-bin-hadoop200.tar.gz
2. 修改 hadoop中的core-site.xml
<property> <name>hadoop.proxyuser.sqoop2.hosts</name> <value>*</value> </property> <property> <name>hadoop.proxyuser.sqoop2.groups</name> <value>*</value> </property>
远程拷贝到其他节点
scp core-site.xml root@slaver1:$HADOOP_HOME/etc/hadoop/
scp core-site.xml root@slaver2: $HADOOP_HOME /etc/hadoop/
3. 配置环境变量
# set sqoop enviroment
exportSQOOP_HOME=/opt/software/sqoop/sqoop-1.99.7-bin-hadoop200
#set JDBC drivers to this directory
exportSQOOP_SERVER_EXTRA_LIB=$SQOOP_HOME/extra
exportPATH=$PATH:$SQOOP_HOME/bin
exportLOGDIR=$SQOOP_HOME/logs
exportBASEDIR=$SQOOP_HOME/base
4. 在$ SQOOP_HOME/conf 下修改 sqoop.properties
# Hadoop configuration directory
org.apache.sqoop.submission.engine.mapreduce.configuration.directory=/opt/software/hadoop/hadoop-2.7.4/etc/hadoop
5. 配置sqoop加载的驱动的⽂件夹,也可以不配置,因为它默认加载lib下的jar,我们只需要将jar放在lib下⾯就可以了
exportSQOOP_SERVER_EXTRA_LIB=/var/lib/sqoop2/
6. 初始化sqoop sqoop2-tool upgrade
7. 检查是否初始化成功 sqoop2-tool verify
8. 启动sqoop服务 sqoop2-server start 关闭sqoop服务 sqoop2-server stop
9. 连接client sqoop2-shell