Hive - Mode (Type of Metastore)

Card Puncher Data Processing


The mode of Hive refers to the type of metastore database:

  • local is an embedded database
  • and remote is a remote database



Running in local mode, means that Hive will use an embedded database (ie Derby).

This mode is mainly used for unit tests because only one process can connect to the derby database at a time.

See: Embedded Metastore Database


Remote Metastore Database. ie traditional standalone RDBMS server.


if the configuration hive.metastore.uris is:

  • empty: local mode
  • non-empty: remote mode

See Hive - Metastore

Documentation / Reference

Discover More
Hive Metastore Er Diagram
Hive - Metastore

All the metadata for Hive tables and partitions are accessed through the Hive Metastore. Derby is the default database for the Hive metastore. See ...
Card Puncher Data Processing
Hive - Scratch Directory

Scratch space for Hive jobs. This directory is used by Hive to store: the plans for different map/reduce stages for the query intermediate outputs of plan operations The default value is...

Share this page:
Follow us:
Task Runner