hive中建表将汇总结果导出到MySQL:
将汇总结果导出到MySQL:
1.建表(可视化建表):
2.sqoop路径下:
bin/sqoop export \
> --connect jdbc:mysql://master:3306/mysql \
> --username root \
> --password 000000 \
> --table shuaixiao \
> --num-mappers 1 \
> --export-dir /user/hive/warehouse/test1 \
> --input-fields-terminated-by ","