hi,3ks for any help! there is a Execution Error infomation below,please tell me how to fix it ? 3ks again
Hive history file=/tmp/searchadmin/hive_job_log_searchadmin_201002261907_1797898701.txt Total MapReduce jobs = 2 Number of reduce tasks not specified. Estimated from input data size: 7 In order to change the average load for a reducer (in bytes): set hive.exec.reducers.bytes.per.reducer=<number> In order to limit the maximum number of reducers: set hive.exec.reducers.max=<number> In order to set a constant number of reducers: set mapred.reduce.tasks=<number> Starting Job = job_201002261500_0005, Tracking URL = http://app-fy-160:6001/jobdetails.jsp?jobid=job_201002261500_0005 Kill Command = /data/hadoop/hadoop/bin/hadoop job -Dmapred.job.tracker=app-fy-160:9001 -kill job_201002261500_0005 2010-02-26 07:07:30,829 map = 0%, reduce =0% 2010-02-26 07:07:42,967 map = 2%, reduce =0% 2010-02-26 07:07:44,993 map = 3%, reduce =0% 2010-02-26 07:07:46,002 map = 4%, reduce =0% 2010-02-26 07:07:48,021 map = 5%, reduce =0% 2010-02-26 07:07:49,037 map = 6%, reduce =0% 2010-02-26 07:07:51,060 map = 7%, reduce =0% 2010-02-26 07:07:52,074 map = 8%, reduce =0% 2010-02-26 07:08:00,184 map = 10%, reduce =0% 2010-02-26 07:08:01,193 map = 11%, reduce =0% 2010-02-26 07:08:03,258 map = 12%, reduce =1% 2010-02-26 07:08:04,332 map = 13%, reduce =2% 2010-02-26 07:08:06,400 map = 14%, reduce =2% 2010-02-26 07:08:09,429 map = 15%, reduce =2% 2010-02-26 07:08:15,588 map = 17%, reduce =3% 2010-02-26 07:08:18,612 map = 19%, reduce =4% 2010-02-26 07:08:21,659 map = 21%, reduce =5% 2010-02-26 07:08:24,717 map = 22%, reduce =5% 2010-02-26 07:08:31,125 map = 24%, reduce =5% 2010-02-26 07:08:34,160 map = 26%, reduce =6% 2010-02-26 07:08:37,184 map = 28%, reduce =7% 2010-02-26 07:08:40,216 map = 29%, reduce =7% 2010-02-26 07:08:43,265 map = 30%, reduce =7% 2010-02-26 07:08:46,296 map = 31%, reduce =7% 2010-02-26 07:08:48,334 map = 32%, reduce =8% 2010-02-26 07:08:49,344 map = 33%, reduce =8% 2010-02-26 07:08:52,369 map = 35%, reduce =8% 2010-02-26 07:08:55,863 map = 36%, reduce =9% 2010-02-26 07:08:57,924 map = 36%, reduce =10% 2010-02-26 07:08:58,932 map = 38%, reduce =10% 2010-02-26 07:09:00,952 map = 39%, reduce =10% 2010-02-26 07:09:03,988 map = 40%, reduce =10% 2010-02-26 07:09:05,023 map = 40%, reduce =11% 2010-02-26 07:09:08,084 map = 41%, reduce =11% 2010-02-26 07:09:11,109 map = 43%, reduce =11% 2010-02-26 07:09:13,124 map = 44%, reduce =12% 2010-02-26 07:09:14,134 map = 45%, reduce =12% 2010-02-26 07:09:16,173 map = 46%, reduce =12% 2010-02-26 07:09:17,184 map = 47%, reduce =13% 2010-02-26 07:09:20,248 map = 48%, reduce =13% 2010-02-26 07:09:23,268 map = 49%, reduce =13% 2010-02-26 07:09:26,288 map = 50%, reduce =14% 2010-02-26 07:09:28,305 map = 51%, reduce =14% 2010-02-26 07:09:29,316 map = 53%, reduce =14% 2010-02-26 07:09:31,360 map = 53%, reduce =15% 2010-02-26 07:09:32,376 map = 55%, reduce =16% 2010-02-26 07:09:34,420 map = 57%, reduce =16% 2010-02-26 07:09:40,508 map = 58%, reduce =16% 2010-02-26 07:09:42,538 map = 59%, reduce =17% 2010-02-26 07:09:43,580 map = 62%, reduce =17% 2010-02-26 07:09:46,676 map = 62%, reduce =18% 2010-02-26 07:09:47,684 map = 63%, reduce =18% 2010-02-26 07:09:49,711 map = 64%, reduce =18% 2010-02-26 07:09:51,744 map = 65%, reduce =19% 2010-02-26 07:09:55,812 map = 66%, reduce =20% 2010-02-26 07:09:56,823 map = 67%, reduce =20% 2010-02-26 07:09:58,840 map = 69%, reduce =20% 2010-02-26 07:10:01,893 map = 70%, reduce =20% 2010-02-26 07:10:03,968 map = 70%, reduce =21% 2010-02-26 07:10:04,977 map = 71%, reduce =21% 2010-02-26 07:10:05,984 map = 72%, reduce =21% 2010-02-26 07:10:08,004 map = 73%, reduce =22% 2010-02-26 07:10:11,020 map = 72%, reduce =22% 2010-02-26 07:10:14,050 map = 75%, reduce =22% 2010-02-26 07:10:15,060 map = 75%, reduce =23% 2010-02-26 07:10:16,079 map = 76%, reduce =23% 2010-02-26 07:10:20,108 map = 77%, reduce =24% 2010-02-26 07:10:23,136 map = 79%, reduce =24% 2010-02-26 07:10:26,206 map = 80%, reduce =24% 2010-02-26 07:10:31,288 map = 80%, reduce =25% 2010-02-26 07:10:32,296 map = 82%, reduce =25% 2010-02-26 07:10:34,344 map = 83%, reduce =25% 2010-02-26 07:10:38,393 map = 84%, reduce =26% 2010-02-26 07:10:41,440 map = 85%, reduce =26% 2010-02-26 07:10:44,479 map = 87%, reduce =26% 2010-02-26 07:10:47,508 map = 90%, reduce =27% 2010-02-26 07:10:49,520 map = 91%, reduce =27% 2010-02-26 07:10:50,534 map = 93%, reduce =27% 2010-02-26 07:10:52,552 map = 93%, reduce =28% 2010-02-26 07:10:53,560 map = 96%, reduce =28% 2010-02-26 07:10:55,577 map = 97%, reduce =29% 2010-02-26 07:10:56,584 map = 98%, reduce =30% 2010-02-26 07:10:59,613 map = 99%, reduce =30% 2010-02-26 07:11:02,655 map = 99%, reduce =31% 2010-02-26 07:11:05,698 map = 99%, reduce =32% 2010-02-26 07:11:08,729 map = 100%, reduce =32% 2010-02-26 07:11:14,868 map = 99%, reduce =33% 2010-02-26 07:11:20,915 map = 100%, reduce =100% Ended Job = job_201002261500_0005 with errors FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver table: CREATE TABLE commclick (comm STRING, navid INT, keyword STRING) PARTITIONED BY(dt STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '9' LINES TERMINATED BY '10'; CREATE TABLE daily_hotkey( keyword STRING, navid STRING, countclick STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE; sql: INSERT OVERWRITE TABLE daily_hotkey select * from (select commclick.keyword keyword,commclick.navid navid,count(commclick.navid) countnavid from commclick GROUP BY commclick.keyword,commclick.navid) t order by keyword,countnavid desc _________________________________________________________________ MSN十周年庆典，查看MSN注册时间，赢取神秘大奖 http://10.msn.com.cn
