sqoop初配置
配置环境
1. 将jar包上传至/opt/software目录下
2. 解压
tar -zxvf sqoop-1.4.7.bin__hadoop-2.6.0.tar.gz -C /opt/app/
3. 改名字
mv sqoop-1.4.7.bin__hadoop-2.6.0/ sqoop-1.4.7
4. 配置环境
vi /etc/profile
export SQOOP_HOME=/opt/app/sqoop-1.4.7
export PATH=$PATH:$SQOOP_HOME/bin
source /etc/profile
5. 修改sqoop-env.sh
vi /opt/app/sqoop-1.4.7/conf/sqoop-env.sh
export HADOOP_COMMON_HOME=/opt/app/hadoop-2.8.5
export HADOOP_MAPRED_HOME=/opt/app/hadoop-2.8.5
export HIVE_HOME=/opt/app/hive-2.3.8
6. 测试sqoop
sqoop version
拷贝mysql驱动jar包
cp /opt/app/hive-2.3.8/lib/mysql-connector-java-8.0.18.jar /opt/app/sqoop-1.4.7/lib/
测试sqoop连接MySQL
sqoop list-databases --connect jdbc:mysql://node1:3306?serverTimezone=UTC --username root --password Jsq123456...
本文来自博客园,作者:jsqup,转载请注明原文链接:https://www.cnblogs.com/jsqup/p/16550996.html