将汇总结果导出到MySQL

①mysql建表test1

②cd /opt/module/sqoop进入scoop路径

bin/sqoop export \
> --connect jdbc:mysql://master:3306/mysql \
> --username root \
> --password 000000 \
> --table test1 \
> --num-mappers 1 \
> --export-dir /user/hive/warehouse/test1 \
> --input-fields-terminated-by ","

 

posted @ 2021-09-29 08:54  CherriesOvO  阅读(41)  评论(0编辑  收藏  举报