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 09F4F10F95 for ; Mon, 9 Dec 2013 06:54:15 +0000 (UTC) Received: (qmail 97178 invoked by uid 500); 9 Dec 2013 06:54:01 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 97114 invoked by uid 500); 9 Dec 2013 06:53:57 -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 97099 invoked by uid 99); 9 Dec 2013 06:53:49 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 09 Dec 2013 06:53:49 +0000 X-ASF-Spam-Status: No, hits=1.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of nitinpawar432@gmail.com designates 209.85.128.53 as permitted sender) Received: from [209.85.128.53] (HELO mail-qe0-f53.google.com) (209.85.128.53) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 09 Dec 2013 06:53:44 +0000 Received: by mail-qe0-f53.google.com with SMTP id nc12so2404693qeb.40 for ; Sun, 08 Dec 2013 22:53:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=QzhL6Q+EtEZKWBy8klx6y1r+Zo9iFOXpGONbynm177E=; b=si2EXJJC8Edyj5HOmLOpn1kusFFmvM8ENbK8qpUVGagEks8Wtm/inu9rIRt1zkFWiD zFargT2XyUet8LrJfGcN4ggJ3uIl+fU0Kc9TEOD7KoZGtsEcae82BAEVKllCLqiMGLXl 0IvPtXtnBweGQissgCoYbGKX5gQYpSfybcAGtxXNKqg7VZgWOypgAI8tsDCRRzM5aX83 9R6fMEMngw/zWNTnSip7pXPbsfMFWwY3oZVTWcqnBFtfAWQXoM9Ay1V0bTep0nc5tU8/ no5v3JsUZZiQNOVYuNE9a4sHHV166YnsWcgYkmV0pSw4yD0ypTDT3UcykcwWKc7uKc2M KObw== MIME-Version: 1.0 X-Received: by 10.224.47.73 with SMTP id m9mr31122329qaf.23.1386572004122; Sun, 08 Dec 2013 22:53:24 -0800 (PST) Received: by 10.224.197.135 with HTTP; Sun, 8 Dec 2013 22:53:24 -0800 (PST) In-Reply-To: References: Date: Mon, 9 Dec 2013 12:23:24 +0530 Message-ID: Subject: Re: Not able to start the hive metastore From: Nitin Pawar To: "user@hive.apache.org" Content-Type: multipart/alternative; boundary=001a1134a7fac2e4fb04ed14739a X-Virus-Checked: Checked by ClamAV on apache.org --001a1134a7fac2e4fb04ed14739a Content-Type: text/plain; charset=ISO-8859-1 Try changing the permissions of the new directory to the user as whom you are going to start metastore service. Thanks, Nitin On Mon, Dec 9, 2013 at 12:17 PM, Biswajit Nayak wrote: > Hi All, > > I had setup the hive in my home directory, but today i moved it to /opt. > After that starting it throws error:- > > *Exception in thread "main" javax.jdo.JDOFatalDataStoreException: Unable > to open a test connection to the given database. JDBC url = > jdbc:derby:;databaseName=metastore_db;create=true, username = APP. > Terminating connection pool. Original Exception: ------* > > *java.sql.SQLException: Failed to start database 'metastore_db', see the > next exception for details.* > > * at > org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown > Source)* > > * at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)* > > * at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)* > > * at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown > Source)* > > * at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown Source)* > > *Thanks* > *Biswajit* > > _____________________________________________________________ > The information contained in this communication is intended solely for the > use of the individual or entity to whom it is addressed and others > authorized to receive it. It may contain confidential or legally privileged > information. If you are not the intended recipient you are hereby notified > that any disclosure, copying, distribution or taking any action in reliance > on the contents of this information is strictly prohibited and may be > unlawful. If you have received this communication in error, please notify > us immediately by responding to this email and then delete it from your > system. The firm is neither liable for the proper and complete transmission > of the information contained in this communication nor for any delay in its > receipt. -- Nitin Pawar --001a1134a7fac2e4fb04ed14739a Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Try changing the permissions of the new directory to the u= ser as whom you are going to start metastore service.=A0

Thanks,
Nitin


On Mon, Dec 9, 2013 at 12:17 PM, Biswajit Nayak <biswajit.nayak@in= mobi.com> wrote:
Hi All,

I had setup the hive in my home= directory, but today i moved it to /opt. After that starting it throws err= or:-

java.sql.SQLException: Fa= iled to start database 'metastore_db', see the next exception for d= etails.

at org.apache.derby.impl.jdbc.SQLExceptionFactory40.get= SQLException(Unknown Source)

at org.apache.derby.impl.jdbc.Util.newEmbedSQLException= (Unknown Source)

at org.apache.derby.impl.jdbc.Util.seeNextException(Unk= nown Source)

at org.apache.derby.impl.jdbc.EmbedConnection.bootDatab= ase(Unknown Source)

at org.apache.derby.impl.jdbc.EmbedConnection.<init&= gt;(Unknown Source)


Thanks
Biswajit

_____________________________________________________________
The information contained in this commun= ication is intended solely for the use of the individual or entity to whom = it is addressed and others authorized to receive it. It may contain confide= ntial or legally privileged information. If you are not the intended recipi= ent you are hereby notified that any disclosure, copying, distribution or t= aking any action in reliance on the contents of this information is strictl= y prohibited and may be unlawful. If you have received this communication i= n error, please notify us immediately by responding to this email and then = delete it from your system. The firm is neither liable for the proper and c= omplete transmission of the information contained in this communication nor= for any delay in its receipt.



--
Nitin Pawar
--001a1134a7fac2e4fb04ed14739a--