Apache Hive SQL Syntax Support¶
This page documents the SQL syntax support for Apache Hive in the General SQL Parser.
Syntax Coverage Corpus¶
GSP tests Hive syntax against 89 documented constructs grouped into 24 categories, each cross-referenced to the specific page in Hive's own documentation that defines it (87 distinct source pages).
Parse coverage¶
Measured on 2026-07-25 against GSP Java 4.1.5.15, the current release. Each construct carries the complete set of examples from Hive's documentation; a construct counts as fully covered only when every one of its examples parses.
| Constructs | Individual statements | |
|---|---|---|
| Fully parsed | 75 of 89 (84%) | 405 of 431 (94%) |
Statements are split using the parser's own statement splitter, so multi-statement examples and procedure bodies are counted correctly.
Categories covered¶
| Category | Constructs |
|---|---|
| DDL | 33 |
| Select | 6 |
| DML | 4 |
| Select / Union | 4 |
| Select / Outer Join Behavior | 4 |
| Data Types | 3 |
| Select / Join Optimization | 3 |
| Select / Joins | 3 |
| Select / Lateral View | 3 |
| Select / SQL Standard Based Hive Authorization | 3 |
| Select / GroupBy | 3 |
| Select / Common Table Expression | 2 |
| Select / SortBy | 2 |
| Select / Variable Substitution | 2 |
| Select / Windowing and Analytics | 2 |
| Select / Enhanced Aggregation, Cube, Grouping and Rollup | 2 |
| Select / Sampling | 2 |
| Select / Sub Queries | 2 |
| Select / Data Types | 1 |
| Select / Indexing | 1 |
| Select / Group By | 1 |
| Select / ImportExport | 1 |
| Select / Operators and User-Defined Functions (UDFs) | 1 |
| Select / Virtual Columns | 1 |
Full construct lists are being published progressively; see Sybase, PostgreSQL or MySQL.
Key Features Supported¶
- Standard SQL operations (SELECT, INSERT, UPDATE, DELETE)
- HiveQL-specific syntax and functions
- Partitioning and bucketing
- User-defined functions (UDFs)
- Window functions and analytical queries
- SerDe and file format specifications