hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adarsh Sharma <>
Subject Error in Running Count
Date Fri, 27 Aug 2010 07:15:37 GMT
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 
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 = 
Kill Command = /home/hadoop/project/hadoop-0.20.2/bin/../bin/hadoop job  
-Dmapred.job.tracker= -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 

Can anybody tell the root cause...

Thanks in Advance..

View raw message