-
1 2022G大数据
-
2
sqoop安装
(1)下载
http://mirror.bit.edu.cn/apache/sqoop/1.4.7/
2、sqoop配置文件
cd /sqoop/sqoop-1.4.7.bin__hadoop-2.6.0/conf
mv sqoop-env-template.sh sqoop-env.sh
3、编辑 sqoop-env.sh脚本
vi sqoop-env.sh
内容如下:
export HADOOP_COMMON_HOME=/home/zjw/hadoop-2.6.0
#Set path to where hadoop-*-core.jar is available
export HADOOP_MAPRED_HOME=/home/zjw/hadoop-2.6.0
#Set the path to where bin/hive is available
export HIVE_HOME=/hive/apache-hive-1.2.2-bin
4、mysql的jar包设置
cd /sqoop/sqoop-1.4.7.bin__hadoop-2.6.0/lib
下载mysql-connector-java-5.1.49.jar rz上传到lib目录下
5、sqoop环境变量设置
vi /etc/profile
在文件最后一行添加
export SQOOP_HOME=/sqoop/sqoop-1.4.7.bin__hadoop-2.6.0
export PATH=$PATH:$SQOOP_HOME/bin
使环境变量立即生效 : source /etc/profile
6、sqoop安装验证
(1)sqoop-version

(2)sqoop连接mysql验证
需要先启动mysql服务
sqoop list-databases -connect jdbc:mysql://localhost:3306/ --username root --password zjw

