Introducing the Hive metastore service

In Hive, the data is stored in HDFS and the table, database, schema, and other HQL definitions are stored in a metastore. The metastore could be any RDBMS database, such as MySQL or Oracle. Hive creates a database and a set of tables in metastore to store HiveQL definitions.

There are three modes of configuring a metastore:

  • Embedded
  • Local
  • Remote

The detailed description and configuration steps of different modes are available in Chapter 1, Developing Hive.

How to do it…

The Hive metastore could be made available as a service. All you need to do is run the following command on the terminal of your machine:

hive --service metastore

How it works…

In the case of a remote metastore configuration, all clients connect to ...

Get Apache Hive Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.