1. Hive Documentation

Documentation for Hive can be found in wiki docs and javadocs.

The Hive wiki is organized in four major sections:
- General Information about Hive
- User Documentation
  - Hive Tutorial
  - HiveQL Language Manual – new information for the CREATE TABLE statement:
    ... [STORED AS file_format] ... file_format: : SEQUENCEFILE | TEXTFILE | RCFILE | ORC | INPUTFORMAT input_format_classname OUTPUTFORMAT output_format_classname
    
    and the hive.default.fileformat variable's description:
    "Default file format for CREATE TABLE statement. Options are TextFile, SequenceFile, RCFile, and Orc."
  - Hive Operators and Functions
  - Hive Web Interface
  - Hive Client
  - Avro SerDe
- Administrator Documentation
  - Installing Hive
  - Configuring Hive – new information for the hive.default.fileformat variable's description:
    "Default file format for CREATE TABLE statement. Options are TextFile, SequenceFile, RCFile, and Orc."
  - Setting Up the Metastore
  - Setting Up Hive Web Interface
  - Setting Up Hive Server
  - Hive on Amazon Web Services
  - Hive on Amazon Elastic MapReduce
- Resources for Contributors
Supplementary documentation describes new features, including:
- ORC file format
- HiveServer2 JDBC
- Decimal data type
- Windowing and analytics functions
- Optimized joins
- Metastore server security (authorization and authentication)
Javadocs describe the Hive API. The supplementary documentation includes a complete set of Javadocs for this release, including the ORC file format.
Hive indexing was added in version 0.7.0; documentation and examples can be found here:
- Indexes – design document (lists the indexing JIRAs with current status, starting with HIVE-417)
- Create/Drop Index – HiveQL language manual
- Bitmap indexes – added in Hive version 0.8.0 (Jira HIVE-1803)
- Indexed Hive – overview and examples by Prafulla Tekawade and Nikhil Deshpande, October 2010
- Tutorial: SQL-like join and index with MapReduce using Hadoop and Hive – blog by Ashish Garg, April 2012

Legal notices