You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Adarsh Sharma <ad...@orkash.com> on 2010/08/27 09:15:37 UTC
Error in Running Count
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..
Re: Error in Running Count
Posted by shixing <pa...@gmail.com>.
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 <ad...@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~