Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 5E7F2DBC6 for ; Tue, 30 Oct 2012 00:37:15 +0000 (UTC) Received: (qmail 87897 invoked by uid 500); 30 Oct 2012 00:37:13 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 87847 invoked by uid 500); 30 Oct 2012 00:37:13 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 87836 invoked by uid 99); 30 Oct 2012 00:37:13 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Oct 2012 00:37:13 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,T_REMOTE_IMAGE X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of shreepadma@cloudera.com designates 209.85.223.176 as permitted sender) Received: from [209.85.223.176] (HELO mail-ie0-f176.google.com) (209.85.223.176) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Oct 2012 00:37:07 +0000 Received: by mail-ie0-f176.google.com with SMTP id k11so8635518iea.35 for ; Mon, 29 Oct 2012 17:36:46 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:x-gm-message-state; bh=zQDo5RNdTedGi0DghSGxawiv7yKDEK5Ub6Jyrt67Bws=; b=febOwhZQc+3Y0LiatsDMuXuuGBsYHAiMw3H8cw7Vyq1bX9kA5UXpnCTGrnv0KnYTVN tcaZK/LaEyQYdvxdlP5qJyJ4KjU34YkgWXuhFokJHr37z96vGLa01P1iIwh4AKZEFxiH PBG3XyeJfrbSgyinDJfSJ4qLHBpnEKR5wKmG+++QNmqFbUG5qqES4mLFRSkxzu/oIJZt 4Jr1Q4+Q+HBdUASHf+l6amjFuICB7C8hYFhSkGDJr4fdLBWSaYdm+nYUdp7lotQcZCAp wIdNNwn4kS+egtPsIdGgSIfy3if746x2Kn9RHlHg+a6bn62VcLA6aRemHUjG2NdbhYzL N2mQ== MIME-Version: 1.0 Received: by 10.50.140.97 with SMTP id rf1mr11150089igb.70.1351557405977; Mon, 29 Oct 2012 17:36:45 -0700 (PDT) Received: by 10.50.76.227 with HTTP; Mon, 29 Oct 2012 17:36:45 -0700 (PDT) In-Reply-To: References: Date: Mon, 29 Oct 2012 17:36:45 -0700 Message-ID: Subject: Re: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask From: Shreepadma Venugopalan To: user@hive.apache.org Content-Type: multipart/alternative; boundary=e89a8f923bc413ad2f04cd3bfbf1 X-Gm-Message-State: ALoCoQnJebFPFrHhT8dCvbibkUgYqegmy3yalXBsNo9Y+d4AunUNLZ07MGdg7ms8IaZbnLoaMkfs X-Virus-Checked: Checked by ClamAV on apache.org --e89a8f923bc413ad2f04cd3bfbf1 Content-Type: text/plain; charset=ISO-8859-1 Hi Robin, Can you attach the execution logs? The logs contain the exception stack. Thanks, Shreepadma On Mon, Oct 29, 2012 at 10:19 AM, Chen Song wrote: > Is there anything interesting on hive.log? > > If you are running Hive shell with root user, by default, the hive.log > should be in /tmp/hive.log. > > BTW, are you using MySQL as your metastore? > > On Mon, Oct 29, 2012 at 12:22 PM, Robin Verlangen wrote: > >> I have to add, while trying to do other operations on hive by hand, it >> also fails. >> >> For example: >> *hive> drop table my_other_table;* >> *FAILED: Error in metadata: >> java.lang.reflect.UndeclaredThrowableException* >> *FAILED: Execution Error, return code 1 from >> org.apache.hadoop.hive.ql.exec.DDLTask* >> >> >> Best regards, >> >> Robin Verlangen >> *Software engineer* >> * >> * >> W http://www.robinverlangen.nl >> E robin@us2.nl >> >> >> >> Disclaimer: The information contained in this message and attachments is >> intended solely for the attention and use of the named addressee and may be >> confidential. If you are not the intended recipient, you are reminded that >> the information remains the property of the sender. You must not use, >> disclose, distribute, copy, print or rely on this e-mail. If you have >> received this message in error, please contact the sender immediately and >> irrevocably delete this message and any copies. >> >> >> >> 2012/10/29 Robin Verlangen >> >>> Hi Chen, >>> >>> The user that ran this job is root and all hdfs folders are also owned >>> by root. >>> >>> Best regards, >>> >>> Robin Verlangen >>> *Software engineer* >>> * >>> * >>> W http://www.robinverlangen.nl >>> E robin@us2.nl >>> >>> >>> >>> Disclaimer: The information contained in this message and attachments is >>> intended solely for the attention and use of the named addressee and may be >>> confidential. If you are not the intended recipient, you are reminded that >>> the information remains the property of the sender. You must not use, >>> disclose, distribute, copy, print or rely on this e-mail. If you have >>> received this message in error, please contact the sender immediately and >>> irrevocably delete this message and any copies. >>> >>> >>> >>> 2012/10/29 Chen Song >>> >>>> Looks to me the permission issue. >>>> >>>> Can you check if the user (which ran the hive query) has write >>>> permission on */user/hive/warehouse/mydatabase.db/mytable?* >>>> >>>> On Mon, Oct 29, 2012 at 8:38 AM, Robin Verlangen wrote: >>>> >>>>> Hi there, >>>>> >>>>> Since today our Hive jobs suddenly fail (nothing changed actually). >>>>> The end looks like this: >>>>> >>>>> *MapReduce Total cumulative CPU time: 38 minutes 31 seconds 260 msec* >>>>> *Ended Job = job_201210291304_0015* >>>>> *Loading data to table mydatabase.mytable* >>>>> *rmr: DEPRECATED: Please use 'rm -r' instead.* >>>>> *Deleted /user/hive/warehouse/mydatabase.db/mytable* >>>>> *Failed with exception null* >>>>> *FAILED: Execution Error, return code 1 from >>>>> org.apache.hadoop.hive.ql.exec.MoveTask* >>>>> *MapReduce Jobs Launched:* >>>>> *Job 0: Map: 196 Reduce: 3 Cumulative CPU: 2311.26 sec HDFS >>>>> Read: 0 HDFS Write: 0 SUCCESS* >>>>> *Total MapReduce CPU Time Spent: 38 minutes 31 seconds 260 msec* >>>>> >>>>> Does anyone have a clue how to resolve this? >>>>> >>>>> Best regards, >>>>> >>>>> Robin Verlangen >>>>> *Software engineer* >>>>> * >>>>> * >>>>> W http://www.robinverlangen.nl >>>>> E robin@us2.nl >>>>> >>>>> >>>>> >>>>> Disclaimer: The information contained in this message and attachments >>>>> is intended solely for the attention and use of the named addressee and may >>>>> be confidential. If you are not the intended recipient, you are reminded >>>>> that the information remains the property of the sender. You must not use, >>>>> disclose, distribute, copy, print or rely on this e-mail. If you have >>>>> received this message in error, please contact the sender immediately and >>>>> irrevocably delete this message and any copies. >>>>> >>>>> >>>> >>>> >>>> -- >>>> Chen Song >>>> >>>> >>>> >>> >> > > > -- > Chen Song > > > --e89a8f923bc413ad2f04cd3bfbf1 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi Robin,

Can you attach the execution logs? The logs co= ntain the exception stack.

Thanks,
Shree= padma

On Mon, Oct 29, 2012 at 10:19 AM, C= hen Song <chen.song.82@gmail.com> wrote:
Is there anything interesting on hive.log?
If you are running Hive shell with root user, by default,= the hive.log should be in /tmp/hive.log.

BTW, are you using MySQL as your metastore?

On Mon, Oct 29, = 2012 at 12:22 PM, Robin Verlangen <robin@us2.nl> wrote:
I have to add, while trying to do other operations on hive by hand, it also= fails.

For example:
hive> drop= table my_other_table;
FAILED: Error in metadata: java.lan= g.reflect.UndeclaredThrowableException
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.= ql.exec.DDLTask


B= est regards,=A0

Robin Verlangen
Software engineer


=

Disclaimer: The informati= on contained in this message and attachments is intended solely for the att= ention and use of the named addressee and may be confidential. If you are n= ot the intended recipient, you are reminded that the information remains th= e property of the sender. You must not use, disclose, distribute, copy, pri= nt or rely on this e-mail. If you have received this message in error, plea= se contact the sender immediately and irrevocably delete this message and a= ny copies.



2012/10/29 Robin Verlang= en <= robin@us2.nl>
Hi Chen,

The user that ran this job is root and all hdfs= folders are also owned by root.

Best rega= rds,=A0

Robin Verlangen
Software engine= er

E robin@us2.nl


Disclaimer: The informati= on contained in this message and attachments is intended solely for the att= ention and use of the named addressee and may be confidential. If you are n= ot the intended recipient, you are reminded that the information remains th= e property of the sender. You must not use, disclose, distribute, copy, pri= nt or rely on this e-mail. If you have received this message in error, plea= se contact the sender immediately and irrevocably delete this message and a= ny copies.



2012/10/29 Chen Song <chen.song.82@gmail.com>
Looks to me the permission issue.=A0

Can you check if th= e user (which ran the hive query) has write permission on=A0/user/hive/warehouse/mydatabase.db/mytable?

On Mon, Oct 29, 2012 at 8:38 = AM, Robin Verlangen <robin@us2.nl> wrote:
Hi there,

Since today our Hive jobs suddenly = fail (nothing changed actually). The end looks like this:

MapReduce Total cumulative CPU time: 38 minutes 31 seconds = 260 msec
Ended Job =3D job_201210291304_0015
Loading data t= o table mydatabase.mytable
rmr: DEPRECATED: Please use = 9;rm -r' instead.
Deleted /user/hive/warehouse/mydatab= ase.db/mytable
Failed with exception null
FAILED: Execution Error= , return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
= MapReduce Jobs Launched:
Job 0: Map: 196 =A0Reduce: 3 = =A0 Cumulative CPU: 2311.26 sec =A0 HDFS Read: 0 HDFS Write: 0 SUCCESS<= /div>
Total MapReduce CPU Time Spent: 38 minutes 31 seconds 260 msec<= /div>

Does anyone have a clue how to resolve this?=

Best regards,=A0

Robin Verla= ngen
Software engineer



Disclaimer: The i= nformation contained in this message and attachments is intended solely for= the attention and use of the named addressee and may be confidential. If y= ou are not the intended recipient, you are reminded that the information re= mains the property of the sender. You must not use, disclose, distribute, c= opy, print or rely on this e-mail. If you have received this message in err= or, please contact the sender immediately and irrevocably delete this messa= ge and any copies.




<= font color=3D"#888888">--
Chen Song







--
Chen Song

=

--e89a8f923bc413ad2f04cd3bfbf1--