Apache Hive
SQL for distributed warehouses
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.