hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: Execution failed with exit status: 3
Date Tue, 08 Oct 2013 17:25:24 GMT
Hi Martin,

Are these tables created by any serde?



On Tue, Oct 8, 2013 at 9:47 PM, Martin, Nick <NiMartin@pssd.com> wrote:

>  Hi Sanjay, thanks for the suggestion. ****
>
> ** **
>
> There are no partitions on either table. ****
>
> ** **
>
> *From:* Sanjay Subramanian [mailto:Sanjay.Subramanian@wizecommerce.com]
> *Sent:* Monday, October 07, 2013 8:19 PM
> *To:* user@hive.apache.org
> *Subject:* Re: Execution failed with exit status: 3****
>
> ** **
>
> Hi Nick****
>
> ** **
>
> How many partitions are there in table t1 and table t2****
>
> If there are many partitions in either t1 or t2 or both can u mod your
> query as follows and see if the error comes up ****
>
> ** **
>
> SELECT****
>
> T1.somecolumn,****
>
> T2.someothercolumn****
>
> FROM ****
>
>     (SELECT * FROM t1 WHERE partition_column1='<some_val>') T1****
>
> JOIN ****
>
>     (SELECT * FROM t2 WHERE partition_column2='<some_val>') T2****
>
> ON (T1.idfield=T2.idfield)****
>
>  ** **
>
> ** **
>
> Thanks****
>
> Regards****
>
> ** **
>
> sanjay****
>
> ** **
>
>  email : sanjay.subramanian@wizecommerce.com****
>
>    Irc : sanjaysub (channel #noc)****
>
>  skype : sanjaysubramanian****
>
> mobile : (925) 399 2692****
>
> ** **
>
> *From: *<Martin>, Nick <NiMartin@pssd.com>
> *Reply-To: *"user@hive.apache.org" <user@hive.apache.org>
> *Date: *Monday, October 7, 2013 5:13 PM
> *To: *"user@hive.apache.org" <user@hive.apache.org>
> *Subject: *Execution failed with exit status: 3****
>
> ** **
>
> Hi all,****
>
>  ****
>
> I’m doing a very basic join in Hive and getting the error below. The
> HiveQL join syntax I’m using is:****
>
>  ****
>
> SELECT****
>
> T1.somecolumn,****
>
> T2.someothercolumn****
>
> FROM t1****
>
> JOIN t2****
>
> ON (t1.idfield=t2.idfield)****
>
>  ****
>
>  ****
>
>  ****
>
> Driver returned: 3.  Errors: OK****
>
> Total MapReduce jobs = 1****
>
> setting HADOOP_USER_NAME  someuser****
>
> Execution failed with exit status: 3****
>
> Obtaining error information****
>
>  ****
>
> Task failed!****
>
> Task ID:****
>
>   Stage-4****
>
>  ****
>
> Logs:****
>
>  ****
>
> FAILED: Execution Error, return code 3 from
> org.apache.hadoop.hive.ql.exec.MapredLocalTask****
>
> I searched through the logs and couldn’t find anything terribly useful,
> although perhaps I’m missing something. Is this a common error I’m just now
> coming across?****
>
>  ****
>
> On Hive 0.11****
>
>  ****
>
> Thanks!****
>
> Nick****
>
> ** **
>
> CONFIDENTIALITY NOTICE
> ======================
> This email message and any attachments are for the exclusive use of the
> intended recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or distribution is
> prohibited. If you are not the intended recipient, please contact the
> sender by reply email and destroy all copies of the original message along
> with any attachments, from your computer system. If you are the intended
> recipient, please be advised that the content of this message is subject to
> access, review and disclosure by the sender's Email System Administrator.*
> ***
>



-- 
Nitin Pawar

Mime
View raw message