Home >> Big Data Hadoop >> Configuring Metastore of Hive in Big Data Hadoop

Configuring Metastore of Hive in Big Data Hadoop

1)-Configuring Metastore means specifying to Hive where the database is stored. Editing the hive-site.xml file,which is in the $HIVE_HOME/conf directory.

2)-Copy the template file using the following command:

$ cd $HIVE_HOME/conf

$ cp hive-default.xml.template hive-site.xml

Edit hive-site.xml and append the following lines between the <configuration> and </configuration> tags:

<name>javax.jdo.option.ConnectionURL</name>

<value>jdbc:mysql://localhost/metastore?createDatabaseIfNotExist=true</value>

<description>metadata is stored in a MySQL server</description>

</property>