a Hive error “Caused by: java.sql.SQLException: Error while processing
statement: FAILED: Execution Error, return code 2 from
org.apache.hadoop.hive.ql.exec.MapRedTask”.
Any ideas as to what is the issue?
Regards,
Vince George | Solutions Manager
rogram gives me error as:
> java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED:
> Execution Error, return code 2 from
> org.apache.hadoop.hive.ql.exec.MapRedTask
> at
> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:192)
> at
<
>>> dwivedishash...@gmail.com> wrote:
>>>
>>>> Addition to my last reply ,,, come out from hive cli.. when you are
>>>> going to run your jdbc code. and dont try to connect using cli when your
>>>> jdbc code is running
>>&g
jdbc code. and dont try to connect using cli when your
>>> jdbc code is running
>>>
>>> Cheers
>>> Shashwat.
>>>
>>>
>>> On Thu, May 10, 2012 at 8:39 PM, shashwat shriparv <
>>> dwivedishash...@gmail.co
arv <
>> dwivedishash...@gmail.com> wrote:
>>
>>> For this error : "
>>> *java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED:
>>> Execution Error, return code 2 from
>>> org.apache.hadoop.hive.ql.exec.MapRedTask
>>&
> Shashwat.
>
>
> On Thu, May 10, 2012 at 8:39 PM, shashwat shriparv <
> dwivedishash...@gmail.com> wrote:
>
>> For this error : "
>> *java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED:
>> Execution Error, retur
his error : "
> *java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED:
> Execution Error, return code 2 from
> org.apache.hadoop.hive.ql.exec.MapRedTask
> at org.apache.hadoop.hive.jdbc.HiveStatement.executeQuer* "
>
> Go to this link :
> http://docs.amazo
For this error : "
*java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED:
Execution Error, return code 2 from
org.apache.hadoop.hive.ql.exec.MapRedTask
at org.apache.hadoop.hive.jdbc.HiveStatement.executeQuer* "
Go to this link :
http://docs.amazonwebse
- Original Message -
From: "Bhavesh Shah"
To: user@hive.apache.org, d...@hive.apache.org
Sent: Thursday, May 10, 2012 6:27:28 AM
Subject: hive failed execution error return code 2 from
org.apache.hadoop.hive.ql.exec.mapredtask
Hello all,
I have one query. It is executing fine on Hi
Hello all,
I have one query. It is executing fine on Hive CLI and returning the result.
But when I am executing it with the help Hive JDBC I am getting error as:
*java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED:
Execution Error, return code 2 from
mapred.job.tracker=localhost:8021 -kill job_201012141048_0023
2010-12-20 15:15:03,295 Stage-1 map = 0%, reduce = 0%
2010-12-20 15:15:09,420 Stage-1 map = 50%, reduce = 0%
... eventually fails after a couple of minutes with:
2010-12-20 17:33:01,113 Stage-1 map = 100%, reduce = 0%
2010-12-20 17:
e = 0%
>> 2010-12-20 15:15:09,420 Stage-1 map = 50%, reduce = 0%
>> ... eventually fails after a couple of minutes with:
>>
>> 2010-12-20 17:33:01,113 Stage-1 map = 100%, reduce = 0%
>> 2010-12-20 17:33:32,182 Stage-1 map = 100%, reduce = 100%
>> Ended Job =
ith errors
FAILED: Execution Error, return code 2 from
org.apache.hadoop.hive.ql.exec.MapRedTask
hive>
almost seems like the reduce task never starts. any help would be appreciated.
sean
To know the root cause of the problem, got to Jobtracker web UI (
IP:50030) and Check Job Tracker History
15:15:09,420 Stage-1 map = 50%, reduce = 0%
> ...
> eventually fails after a couple of minutes with:
>
> 2010-12-20 17:33:01,113 Stage-1 map = 100%, reduce = 0%
> 2010-12-20 17:33:32,182 Stage-1 map = 100%, reduce = 100%
> Ended Job = job_201012141048_0023 with errors
> FAI
ion Error, return code 2 from
org.apache.hadoop.hive.ql.exec.MapRedTask
hive>
almost seems like the reduce task never starts. any help would be appreciated.
sean
15 matches
Mail list logo
