# What is Apache Hive? Definition and meaning

A data warehouse system that runs SQL over files in distributed storage and keeps table metadata in the Hive Metastore.

## Definition

**Apache Hive**: A data warehouse system that runs SQL over files in distributed storage and keeps table metadata in the Hive Metastore.

In short: SQL for the data lake.

## When it is used

Batch SQL on data lakes and table catalogues for many engines.

## Where it fits

Apache Hive belongs to **Storage and formats** in the [Big data](/topics/big-data) topic. These are the other terms in the same group:

- **[Hadoop HDFS](/glossary/hadoop-hdfs)**: An open-source framework for distributed storage (HDFS) and processing (MapReduce, YARN) on clusters of commodity servers.
- **[Apache Hudi](/glossary/apache-hudi)**: An open table format and data platform that supports record-level upserts, deletes and incremental queries on lake storage.
- **[Apache Parquet](/glossary/apache-parquet)**: An open, compressed columnar file format that stores data by column for efficient analytical reads.
- **[Apache Arrow](/glossary/apache-arrow)**: A language-independent in-memory columnar format with libraries for zero-copy exchange, IPC and RPC (Flight).

## Learn more

The full guide to **[Apache Hive](/tools/apache-hive)** explains how it works, when to use it and how it compares with the alternatives, with examples. The [glossary](/glossary) lists every term on the site from A to Z.

Previous term: [Apache Flink](/glossary/apache-flink) · Next term: [Apache Hudi](/glossary/apache-hudi)
