hive>insert overwrite table archive_seller_by_geo_per_day partition(partDate, shard) select sellerTokenID, partDate archiveDate, countryCode, country, countryState, countryCity, count(*) pv, count(distinct ip) uv, partDate, shard from page_visit where partDate >= 20140105 and partDate <= 20140107 group by sellerTokenID, countryCode, country, countryState, countryCity, partDate, shard having sellerTokenID>0;


2014-01-06 10:48:31,590 null map = 0%,  reduce = 0%
2014-01-06 10:48:46,353 null map = 1%,  reduce = 0%
2014-01-06 10:48:48,775 null map = 2%,  reduce = 0%
2014-01-06 10:49:04,329 null map = 5%,  reduce = 0%
2014-01-06 10:49:22,239 null map = 7%,  reduce = 0%
2014-01-06 10:49:25,585 null map = 100%,  reduce = 0%
2014-01-06 10:49:27,814 null map = 12%,  reduce = 0%
2014-01-06 10:49:46,299 null map = 15%,  reduce = 0%
2014-01-06 10:50:06,873 null map = 19%,  reduce = 0%
2014-01-06 10:50:11,868 null map = 100%,  reduce = 0%
2014-01-06 10:50:14,524 null map = 22%,  reduce = 0%
2014-01-06 10:50:30,130 null map = 25%,  reduce = 0%
2014-01-06 10:50:33,458 null map = 26%,  reduce = 0%
2014-01-06 10:50:44,565 null map = 28%,  reduce = 0%
2014-01-06 10:50:51,427 null map = 30%,  reduce = 0%
2014-01-06 10:50:53,719 null map = 100%,  reduce = 0%
2014-01-06 10:50:56,403 null map = 34%,  reduce = 0%
2014-01-06 10:51:15,112 null map = 37%,  reduce = 0%
2014-01-06 10:51:29,410 null map = 41%,  reduce = 0%
2014-01-06 10:51:32,758 null map = 100%,  reduce = 0%
2014-01-06 10:51:35,993 null map = 45%,  reduce = 0%
2014-01-06 10:51:50,467 null map = 48%,  reduce = 0%
2014-01-06 10:52:06,274 null map = 52%,  reduce = 0%
2014-01-06 10:52:07,383 null map = 100%,  reduce = 0%
2014-01-06 10:52:10,282 null map = 56%,  reduce = 0%
2014-01-06 10:52:25,854 null map = 59%,  reduce = 0%
2014-01-06 10:52:40,382 null map = 63%,  reduce = 0%
2014-01-06 10:52:41,565 null map = 100%,  reduce = 0%
2014-01-06 10:52:44,892 null map = 67%,  reduce = 0%
2014-01-06 10:52:55,913 null map = 70%,  reduce = 0%
2014-01-06 10:53:11,398 null map = 74%,  reduce = 0%
2014-01-06 10:53:13,589 null map = 100%,  reduce = 0%
2014-01-06 10:53:15,911 null map = 78%,  reduce = 0%
2014-01-06 10:53:28,068 null map = 82%,  reduce = 0%
2014-01-06 10:53:36,848 null map = 84%,  reduce = 0%
2014-01-06 10:53:43,340 null map = 85%,  reduce = 0%
2014-01-06 10:53:44,579 null map = 100%,  reduce = 0%
2014-01-06 10:53:46,846 null map = 89%,  reduce = 0%
2014-01-06 10:53:56,057 null map = 96%,  reduce = 0%
2014-01-06 10:53:57,162 null map = 100%,  reduce = 0%
2014-01-06 10:54:03,018 null map = 100%,  reduce = 67%
2014-01-06 10:54:06,450 null map = 100%,  reduce = 68%
2014-01-06 10:54:08,777 null map = 100%,  reduce = 69%
2014-01-06 10:54:14,706 null map = 100%,  reduce = 70%
2014-01-06 10:54:17,933 null map = 100%,  reduce = 71%
2014-01-06 10:54:21,429 null map = 100%,  reduce = 72%
2014-01-06 10:54:24,682 null map = 100%,  reduce = 73%
2014-01-06 10:54:26,845 null map = 100%,  reduce = 74%
2014-01-06 10:54:30,375 null map = 100%,  reduce = 75%
2014-01-06 10:54:33,781 null map = 100%,  reduce = 76%
2014-01-06 10:54:36,054 null map = 100%,  reduce = 77%
2014-01-06 10:54:39,347 null map = 100%,  reduce = 78%
2014-01-06 10:54:42,764 null map = 100%,  reduce = 79%
2014-01-06 10:54:44,912 null map = 100%,  reduce = 80%
2014-01-06 10:54:48,182 null map = 100%,  reduce = 81%
2014-01-06 10:54:51,553 null map = 100%,  reduce = 82%
2014-01-06 10:54:53,814 null map = 100%,  reduce = 83%
2014-01-06 10:54:57,005 null map = 100%,  reduce = 84%
2014-01-06 10:55:00,303 null map = 100%,  reduce = 85%
2014-01-06 10:55:06,918 null map = 100%,  reduce = 86%
2014-01-06 10:55:09,084 null map = 100%,  reduce = 87%
2014-01-06 10:55:12,400 null map = 100%,  reduce = 88%
2014-01-06 10:55:15,788 null map = 100%,  reduce = 89%
2014-01-06 10:55:17,930 null map = 100%,  reduce = 90%
2014-01-06 10:55:21,452 null map = 100%,  reduce = 91%
2014-01-06 10:55:24,815 null map = 100%,  reduce = 92%
2014-01-06 10:55:27,028 null map = 100%,  reduce = 93%
2014-01-06 10:55:30,222 null map = 100%,  reduce = 94%
2014-01-06 10:55:33,535 null map = 100%,  reduce = 95%
2014-01-06 10:55:36,771 null map = 100%,  reduce = 96%
2014-01-06 10:55:39,249 null map = 100%,  reduce = 97%
2014-01-06 10:55:42,651 null map = 100%,  reduce = 98%
2014-01-06 10:55:45,888 null map = 100%,  reduce = 99%
2014-01-06 10:55:50,289 null map = 100%,  reduce = 100%

Time taken: 499.09 seconds

日志没有错误，结果也执行正常，但速度太慢，请问可能是什么原因导致的呢？谢谢~~