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 0C052C704 for ; Sun, 21 Jul 2013 06:07:18 +0000 (UTC) Received: (qmail 43388 invoked by uid 500); 21 Jul 2013 06:07:14 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 43308 invoked by uid 500); 21 Jul 2013 06:07:02 -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 43300 invoked by uid 99); 21 Jul 2013 06:06:59 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 21 Jul 2013 06:06:59 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of hivehadooplearning@gmail.com designates 209.85.212.51 as permitted sender) Received: from [209.85.212.51] (HELO mail-vb0-f51.google.com) (209.85.212.51) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 21 Jul 2013 06:06:53 +0000 Received: by mail-vb0-f51.google.com with SMTP id x17so4066950vbf.10 for ; Sat, 20 Jul 2013 23:06:33 -0700 (PDT) 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=SOkuaP9MoG2jaMGADyK4DjQWaYfGZuzo3CI2fk1H6Z0=; b=KI9m5sd9ZsfnjMv6K/xYQzLmyOBOthQdU7Qot1zhB7AjdQPF35bJZKKzeM+XEIrpxG nBODf1jJRxuyUXiMdh/4Te4SYFwK6WDQPSSO8oRbcuj17KS7rJPMLxsBzRlfCGTh2MSY RztnxNkMHjl+bLyPPMy97+y5bi8qdCP+vkjvXbZdwpcGPwz9KrX1Zu5v07i3ZA+hRNRJ 1J1kauI8jLOoGX14N4AG/LBlvh3spFhP3MhCD0m6wOtbjimZxpoYAP4MPrc1KrGFHJ5X i8rX3uWSi+PjAV4KX32r0YMYoP+HW14jU0dI7epHfwMRQgujbrJ4wsN+kTdbeTk1Xcv3 8PqQ== MIME-Version: 1.0 X-Received: by 10.52.188.73 with SMTP id fy9mr6672046vdc.53.1374386793044; Sat, 20 Jul 2013 23:06:33 -0700 (PDT) Received: by 10.52.232.164 with HTTP; Sat, 20 Jul 2013 23:06:33 -0700 (PDT) In-Reply-To: References: Date: Sat, 20 Jul 2013 23:06:33 -0700 Message-ID: Subject: Re: Metadata_db error in Hive 0.8 From: Srinivas Surasani To: user@hive.apache.org Content-Type: multipart/alternative; boundary=bcaec548aadf9562a504e1ff5c28 X-Virus-Checked: Checked by ClamAV on apache.org --bcaec548aadf9562a504e1ff5c28 Content-Type: text/plain; charset=ISO-8859-1 can you check if your metastore database is up ? On Tue, Jul 16, 2013 at 11:50 PM, Maheedhar Reddy wrote: > Hi All, > > I have installed hive 4 months back, i don't have any database installed > in my system. till today it was working fine, but now i'm getting this > metadata error... can anyone please suggest me do i have to create any > settings for derby database to avoid this error?? > > error is like this.................................. > > " FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Failed > to start database 'metastore_db', see the next exception for details. > NestedThrowables: > java.sql.SQLException: Failed to start database 'metastore_db', see the > next exception for details. > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask " > > "You only live once, but if you do it right, once is enough." > > > Cheers, > > Maheedhar Reddy K V > > > http://about.me/maheedhar.kv/# > -- Regards, -- Srinivas Srinivas@cloudwick.com --bcaec548aadf9562a504e1ff5c28 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
can you check if your metastore database is up ?


On Tue, Jul 16, 2= 013 at 11:50 PM, Maheedhar Reddy <maheedhar.kv@gmail.com> wrote:
Hi All,

I have= installed hive 4 months back, i don't have any database installed in m= y system. till today it was working fine, but now i'm getting this meta= data error... can anyone please suggest me do i have to create any settings= for derby database to avoid this error??

error is like this..................................

" FAILED: Error in metadata: javax.jdo.JDOFatal= DataStoreException: Failed to start database 'metastore_db', see th= e next exception for details.
NestedThrowables:
java.sql.SQLException: Failed to start dat= abase 'metastore_db', see the next exception for details.
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec= .DDLTask "

"You only live o= nce, but if you do it right, once is enough."


Cheers,

Maheedhar Reddy K V


http://= about.me/maheedhar.kv/#




--
Regards,-- Srinivas --bcaec548aadf9562a504e1ff5c28--