Hive metastore Configuration with derby
Derby is used as an embedded database. try using
jdbc:derby:metastore_db;create=true
as jdbc-url. see also
To use the metastore fully functional (and by that to be able to access it from different services), try setting up using mysql as described in the document above.
As you are setting up an embedded metastore database, use the property below as JDBC URL:
<property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:derby:metastore_db;create=true </value> <description>JDBC connect string for a JDBC metastore </description></property>
I was also facing similar kind of exception while installing hive. The thing which worked for me was to initialize the derby db. I used the following command to solve the problem : command -> Go to $HIVE_HOME/bin and run the command schematool -initSchema -dbType derby
. You can follow the link http://www.edureka.co/blog/apache-hive-installation-on-ubuntu