This article has multiple issues. Please help improve it or discuss these issues on the talk page. (Learn how and when to remove these template messages)
This article contains content that is written like an advertisement. Please help improve it by removing promotional content and inappropriate external links, and by adding encyclopedic content written from a neutral point of view.(October 2019) (Learn how and when to remove this message)
This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed. Find sources: "Apache Hive" – news · newspapers · books · scholar · JSTOR(May 2023) (Learn how and when to remove this message)
(Learn how and when to remove this message)
Apache Hive
Original author(s)
Facebook, Inc.
Developer(s)
Contributors
Initial release
October 1, 2010; 13 years ago (2010-10-01)[1]
Stable release
3.1.3
/ April 8, 2022; 2 years ago (2022-04-08)[2]
Preview release
4.0.0-beta-1
/ August 14, 2023; 8 months ago (2023-08-14)[2]
Repository
github.com/apache/hive
Written in
Java
Operating system
Cross-platform
Available in
SQL
Type
Data warehouse
License
Apache License 2.0
Website
hive.apache.org
Apache Hive is a data warehouse software project, built on top of Apache Hadoop for providing data query and analysis.[3][4] Hive gives an SQL-like interface to query data stored in various databases and file systems that integrate with Hadoop. Traditional SQL queries must be implemented in the MapReduce Java API to execute SQL applications and queries over distributed data. Hive provides the necessary SQL abstraction to integrate SQL-like queries (HiveQL) into the underlying Java without the need to implement queries in the low-level Java API. Since most data warehousing applications work with SQL-based querying languages, Hive aids the portability of SQL-based applications to Hadoop.[5] While initially developed by Facebook, Apache Hive is used and developed by other companies such as Netflix and the Financial Industry Regulatory Authority (FINRA).[6][7] Amazon maintains a software fork of Apache Hive included in Amazon Elastic MapReduce on Amazon Web Services.[8]
^"Release release-1.0.0 · apache/Hive". GitHub.
^ ab"Apache Hive - Downloads". Retrieved 21 November 2022.
^Venner, Jason (2009). Pro Hadoop. Apress. ISBN 978-1-4302-1942-2.
^Yin Huai, Ashutosh Chauhan, Alan Gates, Gunther Hagleitner, Eric N.Hanson, Owen O'Malley, Jitendra Pandey, Yuan Yuan, Rubao Lee, and Xiaodong Zhang (2014). "Major Technical Advancements in Apache Hive". SIGMOD' 14. pp. 1235–1246. doi:10.1145/2588555.2595630.{{cite conference}}: CS1 maint: multiple names: authors list (link)
^Programming Hive [Book].
^Use Case Study of Hive/Hadoop
^OSCON Data 2011, Adrian Cockcroft, "Data Flow at Netflix" on YouTube
ApacheHive is a data warehouse software project, built on top of Apache Hadoop for providing data query and analysis. Hive gives an SQL-like interface...
Presto, Hive, Impala, StarRocks, Doris, and Pig to safely work with the same tables, at the same time. Iceberg is released under the Apache License....
is used by most of the data processing frameworks Apache Spark, ApacheHive, Apache Flink and Apache Hadoop. In February 2013, the Optimized Row Columnar...
integration, with MapReduce support. There is support also for Apache Pig and ApacheHive. Query language Cassandra introduced the Cassandra Query Language...
Meta Platforms Products and services People Open source Apache Cassandra ApacheHiveApache Thrift Buck FQL Hack HHVM HipHop for PHP Infer MyRocks Open...
metadata to be accessed by means of plug-ins. Several other Apache projects use Calcite.Hive uses Calcite for cost-based query optimization;Drill and Kylin...
security and resource management frameworks used by MapReduce, ApacheHive, Apache Pig and other Hadoop software. Impala is promoted for analysts and...
Meta Platforms Products and services People Open source Apache Cassandra ApacheHiveApache Thrift Buck FQL Hack HHVM HipHop for PHP Infer MyRocks Open...
Storage for Apache Hadoop". Cloudera blog. Retrieved May 4, 2017. RCFile on the Apache Software Foundation website Source Code Hive website Hive page on Hadoop...
modules for Big Data platforms (e.g. ApacheHive/Apache Flink/Apache Spark), which provide certain functionality of Apache POI, such as the processing of Excel...
This list of Apache Software Foundation projects contains the software development projects of The Apache Software Foundation (ASF). Besides the projects...
Meta Platforms Products and services People Open source Apache Cassandra ApacheHiveApache Thrift Buck FQL Hack HHVM HipHop for PHP Infer MyRocks Open...
skin rash HIVE, HIV (human immunodeficiency virus) encephalitis Hive, a highest-level logical section in the Windows Registry ApacheHive, a data warehouse...
Meta Platforms Products and services People Open source Apache Cassandra ApacheHiveApache Thrift Buck FQL Hack HHVM HipHop for PHP Infer MyRocks Open...
Meta Platforms Products and services People Open source Apache Cassandra ApacheHiveApache Thrift Buck FQL Hack HHVM HipHop for PHP Infer MyRocks Open...
Meta Platforms Products and services People Open source Apache Cassandra ApacheHiveApache Thrift Buck FQL Hack HHVM HipHop for PHP Infer MyRocks Open...
Meta Platforms Products and services People Open source Apache Cassandra ApacheHiveApache Thrift Buck FQL Hack HHVM HipHop for PHP Infer MyRocks Open...
for speed-layer output, and Elephant DB, Apache Impala, SAP HANA or ApacheHive for batch-layer output.: 45 To optimize the data set and improve query...
Meta Platforms Products and services People Open source Apache Cassandra ApacheHiveApache Thrift Buck FQL Hack HHVM HipHop for PHP Infer MyRocks Open...
cleansing and transformation process can begin. ApacheHive Sawzall — similar tool from Google "Hadoop: Apache Pig". Retrieved Sep 2, 2011. "[PIG-4167] Initial...