首先下载sqoop:
wget http://mirror.navercorp.com/apache/sqoop/1.4.7/sqoop-1.4.7.bin__hadoop-2.6.0.tar.gz
tar zxvf sqoop-1.4.7.bin__hadoop-2.6.0.tar.gz
mv sqoop-1.4.7.bin__hadoop-2.6.0 /usr/local/sqoop
然后进行部分配置:
cd /usr/local/sqoop/conf
cp sqoop-env-template.sh sqoop-env.sh
vim sqoop-env.sh
# 这里是填写你的hadoop目录位置
export HADOOP_MAPRED_HOME=/usr/local/hadoop
export HADOOP_COMMON_HOME=/usr/local/hadoop
最后是将mysql数据库连接器的jar包放到sqoop的lib目录中:
下载地址:https://dev.mysql.com/downloads/connector/j/5.1.html
将解压出来的 mysql-connector-java-5.1.48-bin.jar 放入sqoop/lib 文件夹中
sqoop/bin目录下测试连接(查看所有数据库):
./sqoop list-databases --connect jdbc:mysql://localhost:3306 --username root --password songzihan