Apache Hive
Apache Hive is a data warehousing software that enables users to read, write, and manage large datasets residing in distributed storage, such as Apache Hadoop's HDFS, using SQL. It provides a SQL-like interface (HiveQL) to query and analyze data, abstracting the complexities of underlying…
Key facts
- First appeared
- 2008
- Category
- technology
- Problem solved
- Apache Hive was created to bridge the gap between SQL-savvy data analysts and the complex, low-level Java MapReduce programming required to query and process vast datasets stored in Hadoop Distributed File System (HDFS). It aimed to make large-scale data analytics accessible by providing a familiar SQL interface over big data, thus enabling data warehousing capabilities on Hadoop.
- Platforms
- Cloud environments (e.g., AWS EMR, Azure HDInsight, Google Cloud Dataproc), Linux (primarily on Hadoop clusters)
Related technologies
Notable users
- Facebook (Meta)
- Netflix
- Yahoo
- Many large enterprises with significant on-premise Hadoop infrastructures