I think you should paste the http://ws-test-lin:50030/jobdetails.jsp?jobid=job_201008270046_0019 's error log
On Fri, Aug 27, 2010 at 3:15 PM, Adarsh Sharma <adarsh.sha...@orkash.com>wrote: > Hello everyone, > I am able to retrieve data from Hive which comes with HAdoopDB > package(SMS).Data is stored in Postgres and metadata is in Mysql > But when I fired a count(1) query , it gives the following error.. > I tried count(1),count(*),count(page_id)hive> select count(1) from > fact_table_olap; Total MapReduce jobs = 1 > Number of reduce tasks determined at compile time: 1 > 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_201008270046_0019, Tracking URL = > http://ws-test-lin:50030/jobdetails.jsp?jobid=job_201008270046_0019 > Kill Command = /home/hadoop/project/hadoop-0.20.2/bin/../bin/hadoop job > -Dmapred.job.tracker=192.168.0.25:54311 -kill job_201008270046_0019 > 2010-08-27 03:10:35,587 map = 0%, reduce =0% > 2010-08-27 03:11:11,760 map = 100%, reduce =100% > Ended Job = job_201008270046_0019 with errors > FAILED: Execution Error, return code 2 from > org.apache.hadoop.hive.ql.exec.ExecDriver > hive> > > Can anybody tell the root cause... > > Thanks in Advance.. > > > -- Best wishes! My Friend~