6-linux集群搭建-Sqoop 组件安装

1.导入包并配置环境变量（master）

需先导入Sqoop包
解压上传的包到指定文件：tar -zxvf sqoop-1.4.7.bin__hadoop-2.6.0.tar.gz -C /opt/software/
然后进入文件夹下改名：mv sqoop-1.4.7.bin__hadoop-2.6.0 sqoop
配置环境变量：vi /etc/profile

export SQOOP_HOME=/opt/software/sqoop
export PATH=$PATH:$SQOOP_HOME/bin
export CLASSPATH=$CLASSPATH:$SQOOP_HOME/lib

然后source一下：source /etc/profile

2.配置Sqoop(master)

进入目录：cd /opt/software/sqoop/conf/
拷贝：cp sqoop-env-template.sh sqoop-env.sh
插入：vi sqoop-env.sh

export HADOOP_COMMON_HOME=/opt/software/hadoop
export HADOOP_MAPRED_HOME=/opt/software/hadoop
export HBASE_HOME=/opt/software/hbase
export HIVE_HOME=/opt/software/hive

将mysql的jar包上传到sqoop的lib目录下

cp mysql-connector-java-5.1.46.jar /opt/software/sqop/lib/

将hive的jar包上传到sqoop的lib目录下

cp hive-common-2.0.0.jar /opt/software/sqoop/lib/

3.启动 Sqoop（master）

启动 Hadoop

start-all.sh

连接mysql：

sqoop list-databases --connect jdbc:mysql://127.0.0.1:3306/ --username
root -P