Hive Metastore Service

A Hive Metastore Service is a metadata database that ...

• Context:
  • It can be referenced by Apache Hive (for Hive tables), ...
• Example(s):
  • Hive Metastore, 2.1.1 (Nov, 2016) [1].
  • Hive Metastore, 1.2.1 (Jun, 2015) [2].
• See: Data Lake, Parquet File.

---

---

References

2016

• http://www.cloudera.com/documentation/archive/cdh/4-x/4-2-0/CDH4-Installation-Guide/cdh4ig_topic_18_4.html
  • The Hive metastore service stores the metadata for Hive tables and partitions in a relational database, and provides clients (including Hive) access to this information via the metastore service API. The subsections that follow discuss the deployment options and provide instructions for setting up a database in a recommended configuration.

2014

• https://www.altiscale.com/blog/rise-hive-metastore-semantic-repository/
  • QUOTE: The Hive metastore does the job well. It provides a service for external processes to remotely access the metastore – this allows for easy integration with other SQL-on- Hadoop frameworks. In addition, the metastore supports a number of technologies such as Derby, MySQL and PostgreSQL for its backend. This removes the need to reinvent the wheel when it comes to safely storing schema and related metadata. In addition, there is also the issue of compatibility. Hive, due to its incumbency, is still the reigning king – or at least has much data locked up in it. It makes no sense for system designers to not offer a way of accessing data stored in Hive. The Hive metastore is becoming a common semantic repository because it meets the needs of multiple tools.

---