This is the Hive Language Manual.

• Hive CLI
  • Variable Substitution
• Data Types
• Data Definition Statements
• Data Manipulation Statements
• Select
  • Group By
  • Sort/Distribute/Cluster/Order By
  • Transform and Map-Reduce Scripts
  • Operators and User-Defined Functions
  • XPath-specific Functions
• Joins
• Lateral View
• Union
• Sub Queries
• Sampling
• Explain
• Virtual Columns
• Locks
• Import/Export
• Configuration Properties
• Authorization
• Statistics
• Archiving