m0_61232019的博客

输入sqoop执行语句sqoop export -connect "jdbc:mysql://HadoopMaster:3306/hive_to_mysql?useUnicode=true&characterEncoding=UTF-8" -username sqoop03 -password 123456 -table hive_resoult1 --fields-terminated-by ',' --export-dir /user/hive_mysql/resoult/resoult1/执行

将mysql-connector-java.jar上传到sqoop的lib目录下（mysql-connector-java.jar在文章前边有下载链接）#将sqoop-env-template.sh复制一份并命名为sqoop-env.sh。这里的/home/mysql5.7是安装mysql的路径，把它对应改成自己的安装路径即可。#解压sqoop-1.4.7.bin_hadoop-2.6.0.tar.gz。#测试sqoop与MySQL之间的连接是否成功。#编辑sqoop-env.sh。