{"id":3903,"date":"2017-09-01T11:14:12","date_gmt":"2017-09-01T11:14:12","guid":{"rendered":"http:\/\/data-flair.training\/blogs\/?p=3903"},"modified":"2017-09-01T11:14:12","modified_gmt":"2017-09-01T11:14:12","slug":"apache-hive-metastore","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/apache-hive-metastore\/","title":{"rendered":"Hive Metastore – Different Ways to Configure Hive Metastore"},"content":{"rendered":"

In this tutorial, we are going to introduce Hive<\/strong> Metastore<\/strong> in detail. Metastore is the central repository of Hive Metadata. It stores the meta data for Hive tables and relations. For example, Schema and Locations etc.<\/p>\n

This Hive tutorial will cover what is Hive Metastore, how the Hive Metastore works, what is Derby in Hive, how to Configure Hive Metastore and What are the Databases Supported by Hive? We will discuss the answer to all the above questions in detail.<\/p>\n

So, let’s start Hive Metastore Tutorial.<\/p>\n

\"Hive<\/a>

Hive Metastore – Different Ways to Configure Hive Metastore<\/p><\/div>\n

What is Hive Metastore?<\/h2>\n

Metastore<\/strong> is the central repository of Apache Hive metadata. It stores metadata for Hive tables (like their schema and location) and partitions <\/strong>in a relational database. It provides client access to this information by using metastore service API.<\/p>\n

Hive metastore consists of two fundamental units:<\/p>\n

    \n
  1. A service\u00a0that\u00a0provides metastore\u00a0access to other\u00a0Apache Hive services.<\/li>\n
  2. Disk storage for\u00a0the Hive metadata which is separate from HDFS<\/strong> storage.<\/li>\n<\/ol>\n

    Hive Metastore Modes<\/h2>\n

    There are three modes for Hive Metastore deployment:<\/p>\n