我使用 hive 来分析数据
我创建表并将本地文件加载到配置单元
当我在 hive 上运行hiveqlselect sum(qlog_test.contlength) from qlog_test where qlog_test.area='HK' limit 10;
卡在 map 上100%减少0%2012-12-08 21:39:28,349 Stage-1 map = 80%, reduce = 0%, Cumulative CPU 29.72 sec2012-12-08 21:39:29,370 Stage-1 map = 80%, reduce = 0%, Cumulative CPU 29.72 sec2012-12-08 21:39:30,385 Stage-1 map = 80%, reduce = 0%, Cumulative CPU 29.72 sec2012-12-08 21:39:31,401 Stage-1 map = 80%, reduce = 0%, Cumulative CPU 29.72 sec2012-12-08 21:39:32,413 Stage-1 map = 80%, reduce = 0%, Cumulative CPU 29.72 sec2012-12-08 21:39:33,423 Stage-1 map = 80%, reduce = 0%, Cumulative CPU 29.72 sec2012-12-08 21:39:34,434 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:35,445 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:36,455 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:37,466 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:38,485 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:39,503 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:40,515 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:41,526 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:42,536 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:43,551 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:44,561 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:45,570 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:46,580 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:47,589 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:48,603 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:49,619 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:50,632 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:51,647 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:52,661 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:53,675 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:54,686 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:55,698 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:56,710 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:57,720 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:58,732 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:39:59,747 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:40:00,758 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:40:01,768 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:40:02,777 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:40:03,786 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:40:04,795 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:40:05,804 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:40:06,815 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:40:07,828 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:40:08,840 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:40:09,854 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec2012-12-08 21:40:10,867 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 35.89 sec
这是我的Hadoop节点详细信息
这是 map /缩小作业详细信息
最佳答案
我有这个问题。确保查看 reducer 日志。参考您的屏幕快照,单击化简行中的1,然后跟踪记录所有数据的文件。然后,单击“全部”,然后查看导致问题的原因。我遇到的问题是IP配置错误,因此映射器和 reducer 无法通信。重新启动系统很有帮助。编辑您的问题,以包括化简日志所说的内容,也许我们可以为您提供进一步的帮助。
关于hadoop - hive 总是减少0%,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/13778136/