You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Sateesh Karuturi <sa...@gmail.com> on 2015/06/16 19:19:11 UTC

error on hive insert query

iam using *hive 1.0.0* and *tez 0.5.2.* when i set
*hive.execution.engine* value
in hive-site.xml to *tez*select query works well... but in case of
*insert* getting
error. the query is :

*insert into table tablename values(intvalue,'string value');*

and the error is :

*FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.tez.Tez Task*

Re: error on hive insert query

Posted by "Jianfeng (Jeff) Zhang" <jz...@hortonworks.com>.
You can refer to the following link to figure out whether this is tez problem

https://cwiki.apache.org/confluence/display/TEZ/How+to+Diagnose+Tez+App


Best Regard,
Jeff Zhang


From: Sateesh Karuturi <sa...@gmail.com>>
Reply-To: "user@tez.apache.org<ma...@tez.apache.org>" <us...@tez.apache.org>>
Date: Wednesday, June 17, 2015 at 1:19 AM
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>, "user@tez.apache.org<ma...@tez.apache.org>" <us...@tez.apache.org>>
Subject: error on hive insert query


iam using hive 1.0.0 and tez 0.5.2. when i set hive.execution.engine value in hive-site.xml to tezselect query works well... but in case of insert getting error. the query is :

insert into table tablename values(intvalue,'string value');

and the error is :

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.Tez Task


Re: error on hive insert query

Posted by "Jianfeng (Jeff) Zhang" <jz...@hortonworks.com>.
You can refer to the following link to figure out whether this is tez problem

https://cwiki.apache.org/confluence/display/TEZ/How+to+Diagnose+Tez+App


Best Regard,
Jeff Zhang


From: Sateesh Karuturi <sa...@gmail.com>>
Reply-To: "user@tez.apache.org<ma...@tez.apache.org>" <us...@tez.apache.org>>
Date: Wednesday, June 17, 2015 at 1:19 AM
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>, "user@tez.apache.org<ma...@tez.apache.org>" <us...@tez.apache.org>>
Subject: error on hive insert query


iam using hive 1.0.0 and tez 0.5.2. when i set hive.execution.engine value in hive-site.xml to tezselect query works well... but in case of insert getting error. the query is :

insert into table tablename values(intvalue,'string value');

and the error is :

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.Tez Task


Re: error on hive insert query

Posted by Hitesh Shah <hi...@apache.org>.
Unless you can pinpoint the problem to something Tez specific, hive-specific questions might be better off being asked on user@hive initially as there is a larger group there that understands Hive as compared to the Tez community. 

FWIW, TezTask error 1 means “something in the Hive layer using Tez or somewhere within Tez itself” had a failure. Without additional logs/stack trace, this is usually impossible to debug/pinpoint where the problem is.  

thanks
— Hitesh

On Jun 16, 2015, at 10:19 AM, Sateesh Karuturi <sa...@gmail.com> wrote:

> iam using hive 1.0.0 and tez 0.5.2. when i set hive.execution.engine value in hive-site.xml to tezselect query works well... but in case of insert getting error. the query is :
> 
> insert into table tablename values(intvalue,'string value');
> 
> and the error is :
> 
> FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.Tez Task
> 
> 


Re: error on hive insert query

Posted by Hitesh Shah <hi...@apache.org>.
Unless you can pinpoint the problem to something Tez specific, hive-specific questions might be better off being asked on user@hive initially as there is a larger group there that understands Hive as compared to the Tez community. 

FWIW, TezTask error 1 means “something in the Hive layer using Tez or somewhere within Tez itself” had a failure. Without additional logs/stack trace, this is usually impossible to debug/pinpoint where the problem is.  

thanks
— Hitesh

On Jun 16, 2015, at 10:19 AM, Sateesh Karuturi <sa...@gmail.com> wrote:

> iam using hive 1.0.0 and tez 0.5.2. when i set hive.execution.engine value in hive-site.xml to tezselect query works well... but in case of insert getting error. the query is :
> 
> insert into table tablename values(intvalue,'string value');
> 
> and the error is :
> 
> FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.Tez Task
> 
>