sqoop

sqoop安装

#修改配置文件

cd /export/servers/sqoop/conf 

mv sqoop-env-template.sh sqoop-env.sh 

vim sqoop-env.sh 
export HADOOP_COMMON_HOME=/export/servers/hadoop-2.7.5  
export HADOOP_MAPRED_HOME=/export/servers/hadoop-2.7.5 
export HIVE_HOME=/export/servers/hive

#加入mysql的jdbc驱动包

cp /hive/lib/mysql-connector-java-5.1.38.jar /export/servers/sqoop/lib/

#验证启动

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