Configuring a Metadata Store for Hive

Hive uses a default H2 database instance that comes with BAM to persist Hive table definitions and other metadata. This configuration is given in <BAM_HOME>/repository/conf/advanced/hive-site.xml file as follows:

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:h2://${CARBON_HOME}/repository/database/metastore_db</value>
  <description>JDBC connect string for a JDBC metastore</description>
</property>
<property>
  <name>javax.jdo.option.ConnectionDriverName</name>
  <value>org.h2.Driver</value>
  <description>Driver class name for a JDBC metastore</description>
</property>
<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value>wso2carbon</value>
  <description>username to use against metastore database</description>
</property>
<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>wso2carbon</value>
  <description>password to use against metastore database</description>
</property>

In production setups, we recommend to use an external database instance such as MySQL, MSSQL, Oracle or Derby, instead of the embedded H2 database. For databases other than H2, you need to create the metastore_db database, while in H2 it is being created. Change the <BAM_HOME>/repository/conf/advanced/hive-site.xml file to point to the external database instance created. If you are on Windows, use the hive-site-win.xml file in the same folder.

For example, the following code connects to an external Oracle database as the Hive metedata store:

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:oracle:thin:@<ip>:<port>:<SID></value>
  <description>JDBC connect string for a JDBC metastore</description>
</property>

<property>
  <name>javax.jdo.option.ConnectionDriverName</name>
  <value>oracle.jdbc.driver.OracleDriver</value>
  <description>Driver class name for a JDBC metastore</description>
</property>

<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value><USERNAME></value>
  <description>username to use against metastore database</description>
</property>

<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value><PASSWORD></value>
  <description>password to use against metastore database</description>
</property>

For databases other than H2, add the database driver to <BAM_HOME>/repository/components/lib and restart the server.