Return-Path: 
 <core-user-return-9375-apmail-hadoop-core-user-archive=hadoop.apache.org@hadoop.apache.org>
Delivered-To: apmail-hadoop-core-user-archive@www.apache.org
Received: (qmail 47225 invoked from network); 2 Oct 2008 19:34:10 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 2 Oct 2008 19:34:10 -0000
Received: (qmail 80652 invoked by uid 500); 2 Oct 2008 19:34:04 -0000
Delivered-To: apmail-hadoop-core-user-archive@hadoop.apache.org
Received: (qmail 80617 invoked by uid 500); 2 Oct 2008 19:34:04 -0000
Mailing-List: contact core-user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:core-user-help@hadoop.apache.org>
List-Unsubscribe: <mailto:core-user-unsubscribe@hadoop.apache.org>
List-Post: <mailto:core-user@hadoop.apache.org>
List-Id: <core-user.hadoop.apache.org>
Reply-To: core-user@hadoop.apache.org
Delivered-To: mailing list core-user@hadoop.apache.org
Received: (qmail 80606 invoked by uid 99); 2 Oct 2008 19:34:04 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Oct 2008 12:34:04 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of edlinuxguru@gmail.com
 designates 74.125.78.27 as permitted sender)
Received: from [74.125.78.27] (HELO ey-out-2122.google.com) (74.125.78.27)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Oct 2008 19:33:03 +0000
Received: by ey-out-2122.google.com with SMTP id 5so404322eyj.35
        for <core-user@hadoop.apache.org>;
 Thu, 02 Oct 2008 12:33:20 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:received:received:message-id:date:from:to
         :subject:in-reply-to:mime-version:content-type
         :content-transfer-encoding:content-disposition:references;
        bh=Z4VaPd7f4KWviQH1wFfKUQnsWVmDnVmnjMyQpiKGlmg=;
        b=tyMr5hYK+s9fPi1vCStIO+JpM3/2GgIF++x4Fxgu2+h78hkzSQhC9DIB4UZYv1daw9
         RTXmxoc24YP2iT3X99upYUVu7dYfd/bWrD6cxzg4SArfGqPaSHsVlxJer4+GZG1RdW4y
         bR3UPsWKzAgSN9uCWfTUu73d9Pfo+0yUKZkaI=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:content-transfer-encoding:content-disposition
         :references;
        b=Pd40vQOxqwo6bC6UsNfZSrJHl2QjVv+Mxpn1hxXoouLIaeGTYe1PHb7lgcfYwOOkS6
         SvLa+7VieFCO+lvJLBHsbW1LZt9bQOIkxs8OO02iR8/4F9OzF/UFfj/37x6434pi4lOD
         9pr0GYmxZ9t9V6KPLk0t9VWGlxyUCLFZvlct4=
Received: by 10.210.120.17 with SMTP id s17mr60752ebc.27.1222976000363;
        Thu, 02 Oct 2008 12:33:20 -0700 (PDT)
Received: by 10.210.48.4 with HTTP; Thu, 2 Oct 2008 12:33:20 -0700 (PDT)
Message-ID: <cbbf4b570810021233p1f138c77r26e72ee3e43056ea@mail.gmail.com>
Date: Thu, 2 Oct 2008 15:33:20 -0400
From: "Edward Capriolo" <edlinuxguru@gmail.com>
To: core-user@hadoop.apache.org
Subject: Re: Hive questions about the meta db
In-Reply-To: <c37158cd0810011835s3ff5c2b1k9db2785676a1efa1@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <c37158cd0810011835s3ff5c2b1k9db2785676a1efa1@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org

I am doing a lot of testing with Hive, I will be sure to add this
information to the wiki once I get it going.

Thus far I downloaded the same version of derby that hive uses. I have
verified that the connections is up and running.

ij version 10.4
ij> connect 'jdbc:derby://nyhadoop1:1527/metastore_db;create=true';
ij> show tables
TABLE_SCHEM         |TABLE_NAME                    |REMARKS
------------------------------------------------------------------------
SYS                 |SYSALIASES                    |
SYS                 |SYSCHECKS                     |
...

vi hive-default.conf
...
<property>
  <name>hive.metastore.local</name>
  <value>false</value>
  <description>controls whether to connect to remove metastore server
or open a new metastore server in Hive Client JVM</description>
</property>

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:derby://nyhadoop1:1527/metastore_db;create=true</value>
  <description>JDBC connect string for a JDBC metastore</description>
</property>

<property>
  <name>javax.jdo.option.ConnectionDriverName</name>
  <value>org.apache.derby.jdbc.ClientDriver</value>
  <description>Driver class name for a JDBC metastore</description>
</property>

<property>
  <name>hive.metastore.uris</name>
  <value>jdbc:derby://nyhadoop1:1527/metastore_db</value>
  <description>Comma separated list of URIs of metastore servers. The
first server that can be connected to will be used.</description>
</property>
...

javax.jdo.PersistenceManagerFactoryClass=org.jpox.PersistenceManagerFactoryImpl
org.jpox.autoCreateSchema=false
org.jpox.validateTables=false
org.jpox.validateColumns=false
org.jpox.validateConstraints=false
org.jpox.storeManagerType=rdbms
org.jpox.autoCreateSchema=true
org.jpox.autoStartMechanismMode=checked
org.jpox.transactionIsolation=read_committed
javax.jdo.option.DetachAllOnCommit=true
javax.jdo.option.NontransactionalRead=true
javax.jdo.option.ConnectionDriverName=org.apache.derby.jdbc.ClientDriver
javax.jdo.option.ConnectionURL=jdbc:derby://nyhadoop1:1527/metastore_db;create=true
javax.jdo.option.ConnectionUserName=
javax.jdo.option.ConnectionPassword=

hive> show tables;
08/10/02 15:17:12 INFO hive.metastore: Trying to connect to metastore
with URI jdbc:derby://nyhadoop1:1527/metastore_db
FAILED: Error in semantic analysis: java.lang.NullPointerException
08/10/02 15:17:12 ERROR ql.Driver: FAILED: Error in semantic analysis:
java.lang.NullPointerException

I must have a setting wrong. Any ideas?