Documentation for Hive release 0.9.0 can be found in wiki docs and javadocs.
The Hive wiki is organized in four major sections:
General Information about Hive
User Documentation
Administrator Documentation
Resources for Contributors
Javadocs describe the Hive API.
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