Hi,
To start HiveDerbyServerMode
In hive these 2 configuration need to configure
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:derby//{derbyIP}: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>
In hive/lib keep these derbyclient.jar,derbytools.jar jars
Start the derby in server mode in this machine {derbyIP}
Hope it helps,
Chinna Rao Lalam
----- Original Message -----
From: Matt Kennedy <[email protected]>
Date: Monday, October 10, 2011 9:48 pm
Subject: HiveDerbyServerMode
To: [email protected]
> I'd like to set up the Hive metastore such that I'm running "hive
> --service hiveserver" which itself would use an embedded Derby
> database. Then my hive clients would connect to the remote metastore.
> In searching this mailing list, I have come across a number of links
> to http://wiki.apache.org/hadoop/HiveDerbyServerMode which does not
> appear to exist anymore.
>
> Has that page been removed because what I'm trying to attempt is a bad
> idea? Or does somebody have alternative instructions for that
> configuration. I've read:
> http://wiki.apache.org/hadoop/Hive/AdminManual/MetastoreAdmin but it
> doesn't specifically cover the case I'm asking about.
>
> Thanks,
> Matt
>
