Sqoop2 1.99.4 安装与使用.pdf

Sqoop2 1.99.4 安装 Sqoop 1.99.4 安装 1.安装准备工作 ： 已经装好的 hadoop 环境是 hadoop-2.5.1 64位 下载的sqoop安装包 （ 意是hadoop200 ） /dist/sqoop/1.99.4/sqoop-1.99.4-bin-hadoop200.tar.gz 2.解压文件到工作目录: tar -xvf sqoop-1.99.3-bin-hadoop200.tar.gz mv sqoop-1.99.4-bin-hadoop200 /usr/local/software/ 3.修改环境变 ： vim /etc/profile 添加如下内容 ： #sqoop export SQOOP_HOME=/usr/local/software/sqoop-1.99.4-bin-hadoop200 export PATH=SQOOPHOME/bin:PATH export CATALINA_HOME=SQOOPHOME/serverexport LOGDIR=SQOOP_HOME/logs 保存退出即时生效 ： source /etc/profile 4.修改sqoop配置 ： vim /usr/local/sqoop-1.99.4-bin-hadoop200/server/conf/perties #修改指向我的hadoop安装目录 org.apache.sqoop.submission.engine.mapreduce.configuration.directory=/usr/local/software/hadoop-2.5.1-64/ #把hadoop目录下的j ar包都引进来 vim /usr/local/software/sqoop-1.99.4-bin-hadoop200/server/conf/perties common.loader=/usr/local/software/hadoop-2.5.1-64/share/hadoop/common/*.j ar,/usr/local/software/hadoop-2.5.1- 64/share/hadoop/common/lib/*.j ar,/usr/local/software/hadoop-2.5.1- 64/share/hadoop/hdfs/*.j ar,/usr/local/software/hadoop-2.5.1-64/share/hadoop/hdfs/lib/*.j ar,/usr/local/software/hadoop- 2.5.1-64/share/hadoop/mapreduce/*.j ar,/usr/local/software/hadoop-2.5.1- 64/share/hadoop/mapreduce/lib/*.j ar,/usr/local/software/hadoop-2.5.1- 64/share/hadoop/tools/*.j ar,/usr/local/software/hadoop-2.5.1-64/share/hadoop/tools/lib/*.j ar,/usr/local/software/hadoop- 2.5.1-64/share/hadoop/yarn/*.j ar,/usr/local/software/hadoop-2.5.1- 64/share/hadoop/yarn/lib/*.j ar,/usr/local/software/hadoop-2.5.1-64/share/hadoop/httpfs/tomcat/lib/*.j ar 或者 在$SQOOP_HOME中建个文件夹例如hadoop_lib ，然后将这些j ar包cp到此文件夹中 ，最后将此文件夹路径添加到common.loader属性 中 ，这种方法更加直观些 5.下载mysql驱动包 mysql-connector-j ava-5.1.16-bin.j ar 并放到 /usr/local/software/sqoop-1.99.4-bin-hadoop200/server/lib/ 目录下 [ 意 ：下载的是 mysql-5.6.13.tar.gz 只需要把里面的 mysql-connector-j ava.5.1.34-bin.j ar 考出来即可 ，这是个坑啊] 6.启动/停止sqoop200