sqoop的安装配置

独孤雨鸿

已于 2024-06-23 16:06:21 修改

阅读量996

点赞数 26

分类专栏：数据同步/迁移工具文章标签： sqoop hadoop hive

于 2024-06-15 16:43:58 首次发布

本文链接：https://blog.csdn.net/v15220/article/details/139704654

版权

数据同步/迁移工具专栏收录该内容

7 篇文章 0 订阅

订阅专栏

1. 上传并解压安装包

tar -zxvf sqoop-1.4.7.bin__hadoop-2.6.0.tar.gz -C ../server/

重命名：mv sqoop-1.4.7.bin__hadoop-2.6.0 sqoop

2. 配置环境变量

sudo vim /etc/profile

# 配置sqoop的环境变量

export SQOOP_HOME=/export/server/sqoop

export PATH=$PATH:$SQOOP_HOME/bin

source /etc/profile

3. 修改sqoop的配置文件

cp /$SQOOP_HOME/conf/sqoop-env-template.sh /$SQOOP_HOME/conf/sqoop-env.sh

vim sqoop-env.sh

#Set path to where bin/hadoop is available

export HADOOP_COMMON_HOME=/export/server/hadoop

#Set path to where hadoop-*-core.jar is available

export HADOOP_MAPRED_HOME=/export/server/hadoop

#set the path to where bin/hbase is available

export HBASE_HOME=/export/server/hbase

#Set the path to where bin/hive is available

export HIVE_HOME=/export/server/hive

#Set the path for where zookeper config dir is

export ZOOCFGDIR=/export/server/ zookeeper/conf

vim $SQOOP_HOME/conf/sqoop-site.xml

添加内容（去掉对应位置原文注释）

<property>
 
    <name>sqoop.metastore.client.record.password</name>
 
    <value>true</value>
 
  </property>
 
<property>
 
    <name>sqoop.metastore.server.location</name>
 
    <value>/tmp/sqoop-metastore/shared.db</value>
 
  </property>
 
  <property>
 
    <name>sqoop.metastore.server.port</name>
 
    <value>16000</value>
 
  </property>