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 D07EC1759B for ; Thu, 4 Jun 2015 13:12:22 +0000 (UTC) Received: (qmail 26055 invoked by uid 500); 4 Jun 2015 13:12:05 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 25989 invoked by uid 500); 4 Jun 2015 13:12:05 -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 25979 invoked by uid 99); 4 Jun 2015 13:12:05 -0000 Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Jun 2015 13:12:05 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id E14BD181A44 for ; Thu, 4 Jun 2015 13:12:04 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.88 X-Spam-Level: ** X-Spam-Status: No, score=2.88 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id YB_vUW3Cob5w for ; Thu, 4 Jun 2015 13:11:59 +0000 (UTC) Received: from mail-wi0-f169.google.com (mail-wi0-f169.google.com [209.85.212.169]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTPS id B740843A5B for ; Thu, 4 Jun 2015 13:11:58 +0000 (UTC) Received: by wifw1 with SMTP id w1so58089759wif.0 for ; Thu, 04 Jun 2015 06:11:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :content-type; bh=Ts//1nUfkXg+Z22GSj9irrxf6Nxq7Xg6bZDxv8Ar52s=; b=Ux9dcZ4PdctUFXDgVtWHoQlfFKkThHjOF5X/8RY387xLZG+AgzkpwO/Xg6ExaKDR5B rngrPCeBuQ2gXAOKbQJAjNW/RFPzO0CVfx1ELxu7G4Xoxh4tp3SvWNsJa+6uuGnaEFT0 a3fRTR9YXS6TKqO75+0uAVvJTZBznkHfG2ghOnhR9Mk/h8YG5gKI3UOzEsx4E+Hr6Bd4 //37Sv3MK1HyNlTsmkPbHyP+nEmSqwnW18qQWpuimVwtqWxBkGp56OEd44TTVXP5HoE6 LqZUz1Lg36xazqyGiMbIrQ41V5yeJisR8vDVd3QJUcq/TkB9mnym6yj1/qs6Y8qadlGw NpaA== X-Received: by 10.194.103.2 with SMTP id fs2mr71776368wjb.151.1433423517981; Thu, 04 Jun 2015 06:11:57 -0700 (PDT) MIME-Version: 1.0 References: <04ac01d0936d$abd1b4f0$03751ed0$@whishworks.com> <04ba01d0936e$1fe45e10$5fad1a30$@whishworks.com> In-Reply-To: From: =?UTF-8?B?SsO2cm4gRnJhbmtl?= Date: Thu, 04 Jun 2015 13:11:47 +0000 Message-ID: Subject: Re: Create ORC Table on Tez Failed To: user@hive.apache.org Content-Type: multipart/alternative; boundary=089e010d84a89a20b30517b0eb40 --089e010d84a89a20b30517b0eb40 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Might be an access right problem of the hive server user. Le jeu. 4 juin 2015 =C3=A0 11:53, Chinna Rao Lalam a =C3=A9crit : > Hi, > > If you are table name is orc_table in the exception i can see the table > name as "test" > > Moving data to: hdfs://:8020/apps/hive/warehouse/test > > Failed with exception Unable to rename: > hdfs://:8020/tmp/hive/hdfs/d240f669-b238-4697-9315-5f77eefff887= /hive_2015-05-20_21-44-22_028_8798585586348522774-1/-ext-10001 > to: *hdfs://:8020/apps/hive/warehouse/test* > > > Please check we are pointing to the correct log.. > > > > On Thu, May 21, 2015 at 8:00 AM, Vijay Bhoomireddy < > vijaya.bhoomireddy@whishworks.com> wrote: > >> Hi, >> >> >> >> We are trying to create a Hive ORC Table with Tez. DDL command for the >> same is >> >> >> >> >> >> create table orc_table ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' >> LINES TERMINATED BY '\n' >> >> STORED AS ORC AS select * from select_table; >> >> >> >> However, it fails with the following error message: >> >> >> >> Moving data to: hdfs://:8020/apps/hive/warehouse/test >> >> Failed with exception Unable to rename: >> hdfs://:8020/tmp/hive/hdfs/d240f669-b238-4697-9315-5f77eefff88= 7/hive_2015-05-20_21-44-22_028_8798585586348522774-1/-ext-10001 >> to: hdfs://:8020/apps/hive/warehouse/test >> >> FAILED: Execution Error, return code 1 from >> org.apache.hadoop.hive.ql.exec.MoveTask >> >> >> >> Can anyone please let me know what could be the likely cause of the issu= e >> and possible way to get rid this error message. We are kind of stuck. >> Please let us know your thoughts. >> >> >> >> Thanks & Regards >> >> Vijay >> >> The contents of this e-mail are confidential and for the exclusive use o= f >> the intended recipient. If you receive this e-mail in error please delet= e >> it from your system immediately and notify us either by e-mail or >> telephone. You should not copy, forward or otherwise disclose the conten= t >> of the e-mail. The views expressed in this communication may not >> necessarily be the view held by WHISHWORKS. > > > > > -- > Hope It Helps, > Chinna > --089e010d84a89a20b30517b0eb40 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Might be an access right problem of the hive server user.

Le=C2=A0jeu. 4 juin 2015 =C3=A0 11:53,=C2=A0= Chinna Rao Lalam <lalamchi= nnarao13@gmail.com> a =C3=A9crit=C2=A0:
Hi,

If you are table name is orc_= table in the exception i can see the table name as "test"

Moving data to: hdfs://<namenode= >:8020/apps/hive/warehouse/test

Failed with exception Unable= to rename: hdfs://<namenode>:8020/tmp/hive/hdfs/d240f669-b238-4697-9= 315-5f77eefff887/hive_2015-05-20_21-44-22_028_8798585586348522774-1/-ext-10= 001 to: hdfs://<namenode>:8020/apps/hive/warehouse/test=


Please check we are = pointing to the correct log..




On Thu, May 21, 2015 at 8:00 AM, Vijay Bhoomireddy <= span dir=3D"ltr"><vijaya.bhoomireddy@whishworks.com> wrote:

Hi,<= u>

=C2=A0

We are trying to create a =C2=A0Hive ORC Table =C2=A0with Tez. D= DL command for the same is

= =C2=A0

=C2=A0

create table orc_table ROW = FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '= \n'

STORED AS ORC AS select * from select_table;

=C2=A0<= /u>

However,= it fails with the following error message:

=C2=A0

Moving data to: hdfs= ://<namenode>:8020/apps/hive/warehouse/test

<= p class=3D"MsoNormal">Failed with exception U= nable to rename: hdfs://<namenode>:8020/tmp/hive/hdfs/d240f669-b238-4= 697-9315-5f77eefff887/hive_2015-05-20_21-44-22_028_8798585586348522774-1/-e= xt-10001 to: hdfs://<namenode>:8020/apps/hive/warehouse/test

FAILED= : Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTa= sk

=C2=A0

Can anyone please let me know what could be the likely cause = of the issue and possible way to get rid this error message. We are kind of= stuck. Please let us know your thoughts.

=C2=A0

Thanks= & Regards

Vijay


The conten= ts of this e-mail are confidential and for the exclusive use of the intende= d recipient. If you receive this e-mail in error please delete it from your= system immediately and notify us either by e-mail or telephone. You should= not copy, forward or otherwise disclose the content of the e-mail. The vie= ws expressed in this communication may not necessarily be the view held by = WHISHWORKS.



<= /div>
--
Hope It Helps,=
Chinna
--089e010d84a89a20b30517b0eb40--