解压: sqoop-1.4.7.bin__hadoop-2.6.0.tar.gz
tar -zxvf sqoop-1.4.7.bin__hadoop-2.6.0.tar.gz
ln -s sqoop-1.4.7.bin__hadoop-2.6.0.tar.gz sqoop
替换 lib中commons-lang3.jar删除替换为commons-lang-2.6.jar
备注: https://mvnrepository.com/可以找到commons-lang-2.6.jar
修改配置:
sqoop-env.sh
mv sqoop-env-template.sh sqoop-env.shvim sqoop-env.sh
export HADOOP_COMMON_HOME=/bigdata/server/hadoop
export HADOOP_MAPRED_HOME=/bigdata/server/hadoop
export HIVE_HOME=/bigdata/server/hive
测试是否成功:
条件mysql,hadoop
/bigdata/server/sqoop/bin/sqoop list-databases --connect jdbc:mysql://127.0.0.1:3306/ --username root -P
123456
mysql导入数据hdfs
/bigdata/server/sqoop/bin/sqoop import
–connect jdbc:mysql://ecs-qar1-0002:3306/test
–username root
–password 123456
–table zy_one
–target-dir /sqoop
hdfs数据查看
hadoop fs -cat /sqoop/*