Apache Hive

SQL for distributed warehouses

Visit Apache Hive official site

What it does

Hive brings SQL queries and table metadata to distributed warehouses and documents integrations with several underlying data-file formats.

When to use it

When organizing analytical tables, read partition, metastore, and DDL references to understand the relationship between table definitions and stored files.