原始命令:
bin/sqoop export
–connect “jdbc:mysql://os1:3306/test?useUnicode=true&characterEncoding=utf-8”
–username root --password 123456
–table sanzijin2
–export-dir /flume/spoolingdir/spooling/20210905/upload-.1630890110313.tmp
–input-fields-terminated-by “\t”
–num-mappers 1
修改后的命令:
/usr/soft/sqoop/sqoop-1.4.4.bin__hadoop-2.0.4-alpha/bin/sqoop export
–connect “jdbc:mysql://192.168.159.128(ip):3306/test(数据库名)?useUnicode=true&characterEncoding=utf-8”
–username root --password 123456
–table sanzijin2(表名)
–export-dir /x/x/(导出到HDFS的路径)
–input-fields-terminated-by “\t”
–num-mappers 1
我的sqoop导出命令1(自用)
最新推荐文章于 2022-12-07 09:37:01 发布