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 the metastore service to query the underlying datastore (MySQL, Oracle, and so on). The communication is done through the Thrift protocol. At the client's side, a user needs to add the following configurations to make the client...
