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:19:51 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 and any command to determine Hive Version
Thanks in Advance..
Re: Error in Running count..
Posted by Dave Brondsema <db...@geek.net>.
If you go to the Tracking URL for that job, it should have some more info
On Fri, Aug 27, 2010 at 3:19 AM, 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 and any command to determine Hive Version
>
> Thanks in Advance..
>
--
Dave Brondsema
Software Engineer
Geeknet
www.geek.net