This is the Hive Language Manual.
- Commands and CLIs
- Commands
- Data Types
- File Formats
- Data Types
- Data Definition Statements
- Data Manipulation Statements
- Data ManipulationDML: Load, Insert, Update, Delete
- Import/Export
- Data Retrieval: Queries
- Select
- Group By
- Sort/Distribute/Cluster/Order By
- Transform and Map-Reduce Scripts
- Operators and User-Defined Functions (UDFs)
- XPath-specific Functions
- Joins
- Join Optimization
- Union
- Lateral View
- Sub Queries
- Sampling
- Virtual Columns
- Windowing and Analytics Functions
- Enhanced Aggregation, Cube, Grouping and Rollup
- Select
- Explain
- Locks
- Authorization
- Configuration Properties