thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Intermediate

Apache Hive

A data warehouse system on Hadoop that lets users query files with a SQL-like language (HiveQL) using schema on read.

Definition

Hive translates HiveQL into MapReduce, Tez or Spark jobs. Its metastore, which stores table schemas and locations, became a de facto standard reused by Spark, Presto/Trino, Athena and the Glue Data Catalog.

Exam tip

The Glue Data Catalog is Hive-metastore compatible; Unity Catalog replaces the legacy Hive metastore in Databricks.

Related terms