作者：乐橙味_367 | 来源：互联网 | 2023-06-08 06:10
原博客地址：http:blog.csdn.netu012772782articledetails52949181sqoop2配置：一、添加sqoop2到系统环境变量中：e
原博客地址：http://blog.csdn.net/u012772782/article/details/52949181
sqoop2配置：
一、添加sqoop2到系统环境变量中：
export SQOOP2_HOME=/opt/application/sqoop/sqoop-1.99.7/
export CATALINA_BASE=$SQOOP2_HOME/server
export PATH=.:$SQOOP2_HOME/bin:$PATH
二、驱动jar包目录：
三、配置文件目录：
$SQOOP2_HOME/conf/sqoop.properties
org.apache.sqoop.submission.engine.mapreduce.configuration.directory=/opt/application/hadoop/hadoop-2.6.4/etc/hadoop
org.apache.sqoop.security.authentication.type=SIMPLE
org.apache.sqoop.security.authentication.handler=org.apache.sqoop.security.authentication.SimpleAuthenticationHandler
org.apache.sqoop.security.authentication.anonymous=true
# Number of milliseconds, submissions created before this limit will be removed, default is one day //锁定提交的job时间，锁定时间内不能删除
org.apache.sqoop.submission.purge.threshold=300000
# JDBC repository provider configuration //jdbc配置目录
org.apache.sqoop.repository.jdbc.url=jdbc:derby:/opt/application/sqoop/sqoop-1.99.7/logs/repository/db;create=true
org.apache.sqoop.log4j.appender.file.File=/opt/application/sqoop/sqoop-1.99.7/logs/sqoop.log //sqoop2日志文件目录
org.apache.sqoop.repository.sysprop.derby.stream.error.file=/opt/application/sqoop/sqoop-1.99.7/logs/derbyrepo.log //错误日志文件目录
四、启停sqoop-server:
$SQOOP2_HOME/bin/sqoop.sh server start
$SQOOP2_HOME/bin/sqoop.sh server stop
或者
$SQOOP2_HOME/bin/sqoop2-server start
$SQOOP2_HOME/bin/sqoop2-server stop
五、验证sqoop2是否启动成功：
方式一：jps查看进程: Bootstrap
方式二：http://hadoop_IP:12000/sqoop/version
方式三：wget -qO - hadoop_IP:12000/sqoop/version
六、启动sqoop客户端：
$SQOOP2_HOME/bin/sqoop.sh client
或者
$SQOOP2_HOME/bin/sqoop2-shell
七、为客户端配置服务器：
sqoop:000> set server --host hadoop000 --port 12000 --webapp sqoop
八、查看服务器端信息：
sqoop:000> show server --all
京公网安备 11010802041100号