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 6F2EE10147 for ; Thu, 27 Feb 2014 07:40:49 +0000 (UTC) Received: (qmail 18522 invoked by uid 500); 27 Feb 2014 07:40:47 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 18478 invoked by uid 500); 27 Feb 2014 07:40:46 -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 18464 invoked by uid 99); 27 Feb 2014 07:40:45 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Feb 2014 07:40:45 +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 dwivedishashwat@gmail.com designates 209.85.217.174 as permitted sender) Received: from [209.85.217.174] (HELO mail-lb0-f174.google.com) (209.85.217.174) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Feb 2014 07:40:39 +0000 Received: by mail-lb0-f174.google.com with SMTP id u14so1143780lbd.19 for ; Wed, 26 Feb 2014 23:40:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=PoKsYIBk7O6tDAN5MZxFGZvdxENRLWhyDW7iHewX2/Q=; b=ZomtS0koVL3piuGBJZiQ/Hcqx6TQUmbMM+MaGBIB+X0D7yCMRk1v/+ZSiuRJrJoilW P+s0AW5RTwBITqsYVc13ADdAlFdlvDCK40MFP3OOzyvYGG3fNMjnrTrXggZJCp/FNtpy eH3khKeMk2z+IOppBlhrR21YOanExFcMbO96DdJ8tVqj40rqw1g0oiH7kaXvERVUVjFy h7sRNL856Awd3tq9OPwEEyGsqtF8uhvvfx2pMvGHTKjhuj4SjMzeZz13ru95njsLIBg7 QYTxZXeb9LIue8V2rWxdhmBfb3/nD0n2JNHaW1h3c23MgZPoRwiSe0DkIxcvyrQdo3da hY4A== X-Received: by 10.152.170.135 with SMTP id am7mr5564372lac.23.1393486819081; Wed, 26 Feb 2014 23:40:19 -0800 (PST) MIME-Version: 1.0 Received: by 10.114.75.137 with HTTP; Wed, 26 Feb 2014 23:39:58 -0800 (PST) In-Reply-To: <1393485753.89254.YahooMailNeo@web190006.mail.sg3.yahoo.com> References: <1393484844.60348.YahooMailNeo@web190003.mail.sg3.yahoo.com> <1393485753.89254.YahooMailNeo@web190006.mail.sg3.yahoo.com> From: shashwat shriparv Date: Thu, 27 Feb 2014 13:09:58 +0530 Message-ID: Subject: Re: Error in metadata: MetaException(message:java.lang.IllegalStateException: Can't overwrite cause) To: "user@hive.apache.org" , Rishabh Bhardwaj Content-Type: multipart/alternative; boundary=089e0122797ad9c56204f35e6e8c X-Virus-Checked: Checked by ClamAV on apache.org --089e0122797ad9c56204f35e6e8c Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable =E2=80=8BCheck if hive server is running and not stopped.=E2=80=8B *Warm Regards_**=E2=88=9E_* * Shashwat Shriparv* [image: http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9][image: https://twitter.com/shriparv] [image: https://www.facebook.com/shriparv] [imag= e: http://google.com/+ShashwatShriparv] [image: http://www.youtube.com/user/sShriparv/videos][image: http://profile.yahoo.com/SWXSTW3DVSDTF2HHSRM47AV6DI/] On Thu, Feb 27, 2014 at 12:52 PM, Rishabh Bhardwaj wrot= e: > > > On Thursday, 27 February 2014 12:37 PM, Rishabh Bhardwaj < > rbnext29@yahoo.com> wrote: > Hi , > > I have created a external table and when I provide the location of the > data for this table I get the following error: > FAILED: Error in metadata: > MetaException(message:java.lang.IllegalStateException: Can't overwrite > cause) > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask > Also I am able to load the same file using PIG Script using the > PigStorage() loader function. > I have the following permissions on the file: rw-rw-r-- > and on the folder where this file resides (Giving the path of this folder > in location in the query ) : drwxrwxr-x > What can be the cause for this and how to correct this error ? > > > --089e0122797ad9c56204f35e6e8c Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
=E2=80=8BCheck if hive server= is running and not stopped.=E2=80=8B


Warm Regards_
=E2=88=9E_
= Shashwat Shrip= arv
<= font size=3D"4">
3D"http://www.linke=3D"ht=3D"https://www.f=3D"http://google.c=3D"http://www.you=<= font size=3D"4">3D"http://profil== <= /span>= <= /span>


On Thu, Feb 27, 2014 at 12:52 PM, Rishab= h Bhardwaj <rbnext29@yahoo.com> wrote:


On Thursd= ay, 27 February 2014 12:37 PM, Rishabh Bhardwaj <rbnext29@yahoo.com> wrote:
Hi ,

I have created a external table and when I provide= the location of the data for this table I get the following error:
FAILED: Error in metadata: MetaException(message:java.lang.IllegalStat= eException: Can't overwrite cause)
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.= DDLTask
Also I am able to load the same file using PIG Script using the PigSto= rage() loader function.
I have the following permissions on the file:=C2=A0=C2=A0 rw-rw-r--
and on the folder where this file resides (Giving the path of this folder i= n location in the query ) : drwxrwxr-x
What can be the cause for this and how to correct this error ?


<= /div>

--089e0122797ad9c56204f35e6e8c--