sqoop导出数据到mysql报错_sqoop导出数据到mysql程序长时间执行未完成，且mr控制台也没有报错，如何排查...

版权声明：博主只是整理以前学习的笔记或者遇到的问题，内容太过零碎且现网上的资源已难分辨真实出处，如有侵权请及时联系博主进行删除，谢谢。novicedriver@163.comhttps://blog.csdn.net/sltylzx/article/details/88926591

1.当sqoop导出程序长时间执行未完成，且mr控制台也没有报错

[code][w4xj@node202 sqoop-1.4.6.bin__hadoop-2.0.4-alpha]$ bin/sqoop export \

> --connect jdbc:mysql://node202:3306/company \

> --username root \

> --password 123456 \

> --table staff \

> --num-mappers 1 \

> --export-dir /user/hive/warehouse/staff_hive \

> --input-fields-terminated-by "\t"

Warning: /opt/module/sqoop-1.4.6.bin__hadoop-2.0.4-alpha/bin/../../hbase does not exist! HBase imports will fail.

Please set $HBASE_HOME to the root of your HBase installation.

Warning: /opt/module/sqoop-1.4.6.bin__hadoop-2.0.4-alpha/bin/../../hcatalog does not exist! HCatalog jobs will fail.

Please set $HCAT_HOME to the root of your HCatalog installation.

Warning: /opt/module/sqoop-1.4.6.bin__hadoop-2.0.4-alpha/bin/../../accumulo does not exist! Accumulo imports will fail.

Please set $ACCUMULO_HOME to the root of your Accumulo installation.

19/03/31 11:02:55 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6

19/03/31 11:02:55 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.

19/03/31 11:02:55 INFO manager.MySQLM