Chapter 02 :Metastore and how to configure it

METASTORE

Internal database of hive which is primarially responsible for keeping the metadata information of the table like table name, table schema, table column information, partitioned key information if any.


Note
By default hive will come up with the DERBY database , however we can also configure mysql like THRIFT SERVER extra as hive metastore.


HOW TO CONFIGURE METASTORE IN HIVE

There are two section :-

1. Connection URL
   
   Hive-site.xml
   <property>
   <name>javax.dbo.option.connectionURL</name>
   <value>jdbc.derby; databasename =/var/lib/hive/metastore/metastore_db; create =true;</value>
   <description>Connectionstring for JDBC metastore</description>
   </property>
   
   
   
2. Driver Class Details
   
   Hive-site.xml
   <property>
   <name>javax.dbo.option.ConnectionDriverName</name>
   <value>org.apache.derby.jdbc.EmbeddedDriver</value>
   <description>Driver Class name for JDBC metastore</description>
   </property>
   
   
   
   
   metastore  is generallly one of the configuaration file.