大数据之Sqoop

一、配置

1、mv sqoop-env-template.sh sqoop-env.sh

2、sqoop-env.sh添加:

export HADOOP_COMMON_HOME=/opt/module/hadoop-3.1.4

export HADOOP_MAPRED_HOME=/opt/module/hadoop-3.1.4

export HIVE_HOME=/opt/module/hive

export ZOOKEEPER_HOME=/opt/module/zookeeper

export ZOOCFGDIR=/opt/module/zookeeper/conf

3、导入mysql连接驱动包至lib目录下:mysql-connector-java-5.1.48-bin.jar

4、测试连接:

bin/sqoop list-databases --connect jdbc:mysql://hadoop102:3306 --username root --password 123456