# Apache Hive

> A tool that puts SQL on top of Hadoop files.

**Field:** Data Engineering  
**Category:** Processing  
**Also known as:** Hive, HiveQL

## Think of it like

It is like a helper who hears one plain ask. Then they turn it into a list of jobs for lots of workers.

## Definition

Apache Hive is a free tool that lets people ask questions of Hadoop files in SQL. It began at Facebook and was opened to all in 2008. It turns each query into jobs that run across the cluster. It reads the files where they sit. It keeps a list of tables and their columns, called the Hive Metastore. Newer engines are faster, but that list lives on.

## Example

An analyst writes one SELECT in Hive. Hive turns it into jobs that read 2 TB of log files on 50 machines.

## Example code

```sql
CREATE EXTERNAL TABLE logs (ts STRING, page STRING)
STORED AS PARQUET
LOCATION 'hdfs:///data/logs/';
```

A Hive table over files that already exist. Dropping the table leaves the files where they are.

## Why it matters

It showed that people will use big data if they can ask in SQL. Its Metastore is still the table list many lake tools read.

## Common mistake

Expecting quick answers. A classic Hive query takes minutes, because each one starts a batch of jobs.

## Three principles

- **SQL in.** People write plain SQL.
- **Jobs out.** Hive turns it into cluster jobs.
- **A table list.** The Metastore names every table.

## Related terms

- [Apache Hadoop](https://learn.benibix.com/term/data/apache-hadoop)
- [Hive Metastore (HMS)](https://learn.benibix.com/term/data/hive-metastore)
- [MapReduce](https://learn.benibix.com/term/data/mapreduce)
- [Query Engine](https://learn.benibix.com/term/data/query-engine)

---

Source: https://learn.benibix.com/term/data/apache-hive
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-19
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
