sqoop部署
1.解压sqoop-1.4.7
tar -zxvf sqoop-1.4.7.bin__hadoop-2.6.0.tar.gz
2.重命名sqoop,将名称改简短一点
mv sqoop-1.4.7.bin__hadoop-2.6.0 sqoop-1.4.7
3.到root用户下修改环境变量
su root
vi /etc/profile
新增export SQOOP_HOME=/home/hadoop/sqoop-1.4.7
在PATH尾部增加 :$SQOOP_HOME/bin
4.退出root用户,来到conf下将sqoop-env-template.sh复制成sqoop-env.sh
exit
cd sqoop-1.4.7
ls
cd conf/
ls
cp sqoop-env-template.sh sqoop-env.sh
vi sqoop-env.sh
5.修改sqoop-env.sh的环境
vi sqoop-env.sh
export HADOOP_COMMON_HOME=/home/hadoop/hadoop-2.7.4
export HADOOP_MAPRED_HOME=/home/hadoop/hadoop-2.7.4
source sqoop-env.sh
6.返回将sqoop-1.4.7.ar复制到 $HADOOP_HOME/share/hadoop/mapreduce/
cp sqoop-1.4.7.jar $HADOOP_HOME/share/hadoop/mapreduce/
来到$HADOOP_HOME/share/hadoop/mapreduce/看看有没有
cd $HADOOP_HOME/share/hadoop/mapreduce/
ls
7.将JDBC jar包拷贝到将sqlserver和MySQL分别需要用到的jar包拷贝至$SQOOP_HOME/lib下(自己选择拷贝什么jar)
cd
cp mysql-connector-java-5.1.40-bin.jar $SQOOP_HOME/lib/
cp sqljdbc4.jar $SQOOP_HOME/lib/
8.测试查看所有数据库
sqoop list-databases --connect jdbc:mysql://datanode1:3306/ --username root --password 123456