一、实验环境
hadoop-2.7.2
apache-hive-1.2.1-bin
sqoop-1.99.6-bin-hadoop200
二、安装Sqoop
1、解压
在/opt/文件夹下执行命令
tar -zxvf sqoop-1.99.6-bin-hadoop200.tar.gz
2、在/etc/profile中添加引用
进入profile文件
vim /etc/profile
export SQOOP2_HOME=/opt/sqoop-1.99.6-bin-hadoop200
export CATALINA_BASE=$SQOOP2_HOME/server
export PATH=.:$SQOOP2_HOME/bin:$PATH
source /etc/profile
3、创建logs文件夹
切换到/opt/目录下,创建文件夹
mkdir logs
cd logs
查看文件夹路径
pwd
/opt/sqoop-1.99.6-bin-hadoop200/logs
4、将mysql-connector-java-5.1.25-bin.jar导入到/opt/sqoop-1.99.6-bin-hadoop200/server/lib下面
5、修改server/conf下面文件
(1)sqoop.properties
将@LOGDIR@替换为之前的文件夹logs路径:/opt/sqoop-1.99.6-bin-hadoop200/logs
将derby的路径,@BASEDIR@修改为:/opt/sqoop-1.99.6-bin-hadoop200
将Hadoop的conf文件路径修改
org.apache.sqoop.submission.engine.mapreduce.configuration.directory=/opt/hadoop-2.7.2/etc/hadoop
(2)catalina.properties
引入相关包,将原来的common.loader注释
common.loader=${
catalina.base}/lib,${
catalina.base}/lib/*.jar,${
catalina.home}/lib,${
catalina.home}/lib/*.jar,${
catalina.home}/../lib/*.jar,/opt/hadoop-2.7.2/share/hadoop/common/*.jar,/opt/hadoop-2.7.2/share/hadoop/common/lib/*.jar,/opt/hadoop-2.7.2/share/hadoop/hdfs/*.jar,/opt/hadoop-2.7.2/share/hadoop/hdfs/lib/*.jar,/opt/hadoop-2.7.2/share/hadoop/mapreduce/*.jar,/opt/hadoop-2.7.2/share/hadoop/mapreduce/lib/*.jar,/opt/hadoop-2.7.2/share/hadoop/tools/*.jar,/opt/hadoop-2.7.2/share/hadoop/tools/li