BI Vendors

Apache Hive

Apache Hive

Apache Hive is software that assists in managing large data sets in Hadoop. Specifically, Hive allows users to query, summarize and analyze data. To do this, Hive uses a query language similar to SQL, called HiveQL. HiveQL is highly flexible, and allows for custom, non HiveQL MapReduce expressions.

HiveQL supports a variety of file types, such as ORC, TEXTFILE, RCFILE and SEQUENCEFILE.

Background
Chairman: Brett Porter (Apache Software Foundation chair)
Creator: Facebook
Timeline:
2007: Development of Hive software begins at Facebook.
2008: Hive is released as open source software

The Apache Software Foundation is based out of Forest Hill, Maryland, USA.