Metastore is the internal database for Hive, it is the central repository of Hive Metadata. In this Metastore all the tables information, tables schema, column information, partitioning information will get stored. By default Hive will come up with Derby database as its Metastore. As the default Metastore is Derby, we need not to configure the same, if we want to change the database then we must configure explicitly.
If we want to configure the Hive Metastore explicitly(other than Derby), we can do so in "hive-site.xml". As part of Metastore configuration there are two parts:
- Setting of Connection Url
- Setting of Driver name for the same
 |
| Configuration of HIVE Metastore |
