# Hive Metastore (HMS)

> The catalog that came with Apache Hive. Many tools still use it.

**Field:** Data Engineering  
**Category:** Storage & Warehousing  
**Also known as:** HMS, Apache Hive Metastore

## Think of it like

It is like an old card index in a library. Many readers still use it to find books.

## Definition

Hive Metastore is the catalog that came with Apache Hive. It stores facts about each table: its name, its columns and where its files live. Other engines, such as Spark and Impala, read it through a service. For years, most Hadoop lakes used it. Many lakes still run it, while newer ones often pick other catalogs.

## Example

A bank's Spark jobs find each table in its Hive Metastore. A move to Unity Catalog means copying those entries.

## Why it matters

Lots of older lakes depend on it. Moving off it is a common step when a firm picks a newer catalog.

## Common mistake

Thinking you need Hive to use it. Spark and other engines can use the metastore with no Hive queries at all.

## Three principles

- **Came with Hive.** Part of the Apache Hive project.
- **Tables and partitions.** Names, columns and file places.
- **Shared service.** Spark and Impala read it too.

## Related terms

- [Table Catalog](https://learn.benibix.com/term/data/table-catalog)
- [Apache Hadoop](https://learn.benibix.com/term/data/apache-hadoop)
- [Apache Spark](https://learn.benibix.com/term/data/apache-spark)
- [Unity Catalog](https://learn.benibix.com/term/data/unity-catalog)
- [Data Partitioning](https://learn.benibix.com/term/data/data-partitioning)
- [Hadoop Distributed File System (HDFS)](https://learn.benibix.com/term/data/hdfs)

![Spark, which writes, and Trino, which reads, both point down to a highlighted table catalog that says orders is now version 3. From the catalog, a solid arrow leads to orders version 3 with the new rows, and a dashed line to the old version 2. A note says a write swaps the pointer in one step, so both engines see version 3.](https://learn.benibix.com/diagrams/dat3-table-catalog.svg)

---

Source: https://learn.benibix.com/term/data/hive-metastore
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
