This is the Hive Language Manuala

• Data Definition Statements
• Data Manipulation Statements
• Hive Authorization
• Hive Cli
• Select
  • GroupBy
  • SortBy/DistributeBy/ClusterBy/OrderBy
  • Transform and Map-Reduce Scripts
  • Operators and User-Defined Functions
  • XPath-specific Functions
• Joins
• Lateral View
• Union
• Sub Queries
• Sampling
• Explain
• VirtualColumns
• Locks