Apache Hive SQL Parser Support in GSP¶
Explore the Apache Hive SQL Parser product page
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 documentation that defines it (87 distinct source pages).
Parse coverage¶
Measured against GSP Java 4.2.8 on 2026-08-31 (UTC) (artifact sha256 1117856ef134). Each construct below carries the complete set of examples from the Hive documentation; a construct counts as fully covered only when every one of its examples parses. Percentages are pass rates over this documented-example corpus — not a percentage of the entire SQL dialect.
| Constructs fully parsed | Individual statements parsed | |
|---|---|---|
| All constructs | 75 of 89 (84%) | 405 of 431 (94%) |
| SELECT (queries) | 39 of 41 (95%) | 145 of 147 (99%) |
| DML (INSERT / UPDATE / DELETE / MERGE) | 11 of 11 (100%) | 23 of 23 (100%) |
| Stored procedures | 0 of 1 (0%) | 0 of 1 (0%) |
Statements are split using the parser's own statement splitter, so multi-statement examples and procedure bodies are counted correctly. The SELECT, DML and stored-procedure rows classify each statement by its parsed statement type: a construct is counted in a row when its examples contain at least one statement of that class, and is fully parsed when all of them parse. Stored procedures covers CREATE PROCEDURE / FUNCTION / PACKAGE / TRIGGER definitions and anonymous blocks.
Machine-readable: dialect data (JSON) · all-dialect matrix · coverage matrix overview
All 89 constructs¶
| Construct | Category | Parses | Specified in |
|---|---|---|---|
Data Types Char |
Data Types | all 1 | Hive docs |
Data Types Decimals |
Data Types | 7 of 8 | Hive docs |
Data Types Floating Point Types |
Data Types | all 4 | Hive docs |
Abort Transactions |
DDL | all 1 | Hive docs |
Alter Column |
DDL | all 10 | Hive docs |
Alter Partition |
DDL | 7 of 13 | Hive docs |
Alter Table |
DDL | 10 of 11 | Hive docs |
Alter View As Select |
DDL | 0 of 1 | Hive docs |
analyze external table periodically |
DDL | 6 of 9 | Hive docs |
basic example of using schedules |
DDL | 4 of 6 | Hive docs |
Bucketed Tables |
DDL | all 3 | Hive docs |
Create Table |
DDL | all 15 | Hive docs |
Create Temporary Macro |
DDL | all 3 | Hive docs |
Create View |
DDL | all 1 | Hive docs |
Describe Database |
DDL | all 2 | Hive docs |
Describe Partition |
DDL | all 5 | Hive docs |
Describe Table/View/Materialized View/Column |
DDL | all 2 | Hive docs |
Drop Database |
DDL | all 2 | Hive docs |
Drop Index |
DDL | all 1 | Hive docs |
Drop Materialized View |
DDL | all 1 | Hive docs |
Drop Table |
DDL | all 1 | Hive docs |
Drop Temporary Macro |
DDL | all 1 | Hive docs |
Drop View |
DDL | all 2 | Hive docs |
Exchange Partition |
DDL | all 4 | Hive docs |
Exchange Partition |
DDL | all 6 | Hive docs |
Exchange Partition |
DDL | all 4 | Hive docs |
Ingestion |
DDL | 9 of 11 | Hive docs |
materialized view rebuild |
DDL | 16 of 18 | Hive docs |
Permanent Functions |
DDL | all 1 | Hive docs |
Show Columns |
DDL | all 13 | Hive docs |
Show Compactions |
DDL | all 1 | Hive docs |
Show Locks |
DDL | all 1 | Hive docs |
Show Tables/Views/Materialized Views/Partitions/Indexes |
DDL | all 20 | Hive docs |
Show Transactions |
DDL | all 1 | Hive docs |
Temporary Functions |
DDL | 1 of 2 | Hive docs |
Use Database |
DDL | all 2 | Hive docs |
Inserting data into Hive Tables from queries |
DML | all 1 | Hive docs |
Inserting values into tables from SQL |
DML | all 6 | Hive docs |
Loading files into tables |
DML | all 2 | Hive docs |
Merge |
DML | all 1 | Hive docs |
ALL and DISTINCT Clauses |
Select | all 3 | Hive docs |
HAVING Clause |
Select | all 2 | Hive docs |
LIMIT Clause |
Select | all 3 | Hive docs |
Partition Based Queries |
Select | all 2 | Hive docs |
REGEX Column Specification |
Select | all 1 | Hive docs |
WHERE Clause |
Select | all 1 | Hive docs |
CTE in Select Statements |
Select / Common Table Expression | all 5 | Hive docs |
CTE in Views, CTAS, and Insert Statements |
Select / Common Table Expression | all 7 | Hive docs |
Union Types |
Select / Data Types | all 3 | Hive docs |
Grouping function |
Select / Enhanced Aggregation, Cube, Grouping and Rollup | all 1 | Hive docs |
Grouping__ID function |
Select / Enhanced Aggregation, Cube, Grouping and Rollup | all 1 | Hive docs |
Group By |
Select / Group By | all 4 | Hive docs |
Map-side Aggregation for Group By |
Select / GroupBy | all 2 | Hive docs |
Multi-Group-By Inserts |
Select / GroupBy | all 1 | Hive docs |
statement and group by clause |
Select / GroupBy | 2 of 3 | Hive docs |
ImportExport |
Select / ImportExport | all 12 | Hive docs |
Configuration Parameters for Hive Indexes |
Select / Indexing | all 18 | Hive docs |
Enhancements for Star Joins |
Select / Join Optimization | all 4 | Hive docs |
Prior Support for MAPJOIN |
Select / Join Optimization | all 3 | Hive docs |
Star Schema Example |
Select / Join Optimization | 0 of 1 | Hive docs |
Join Syntax |
Select / Joins | all 4 | Hive docs |
Joins Examples |
Select / Joins | all 14 | Hive docs |
MapJoin Restrictions |
Select / Joins | all 2 | Hive docs |
Lateral View |
Select / Lateral View | all 2 | Hive docs |
Multiple Lateral Views |
Select / Lateral View | all 3 | Hive docs |
Outer Lateral Views |
Select / Lateral View | 1 of 2 | Hive docs |
Operators and User-Defined Functions (UDFs) |
Select / Operators and User-Defined Functions (UDFs) | all 32 | Hive docs |
Join Predicate on Null Supplying Table |
Select / Outer Join Behavior | all 1 | Hive docs |
Join Predicate on Preserved Row Table |
Select / Outer Join Behavior | all 1 | Hive docs |
Where Predicate on Null Supplying Table |
Select / Outer Join Behavior | all 1 | Hive docs |
Where Predicate on Preserved Row Table |
Select / Outer Join Behavior | all 1 | Hive docs |
Sampling Block Sampling |
Select / Sampling | all 3 | Hive docs |
Sampling Bucketized Table |
Select / Sampling | all 1 | Hive docs |
Difference between Sort By and Order By |
Select / SortBy | all 1 | Hive docs |
Setting Types for Sort By |
Select / SortBy | all 6 | Hive docs |
Managing Object Privileges |
Select / SQL Standard Based Hive Authorization | all 3 | Hive docs |
Object Privilege Commands |
Select / SQL Standard Based Hive Authorization | all 2 | Hive docs |
Role Management Commands |
Select / SQL Standard Based Hive Authorization | all 10 | Hive docs |
Subqueries in the FROM Clause |
Select / Sub Queries | all 2 | Hive docs |
Subqueries in the WHERE Clause |
Select / Sub Queries | all 2 | Hive docs |
Column Aliases for Schema Matching |
Select / Union | all 2 | Hive docs |
Column Type Conversion |
Select / Union | all 1 | Hive docs |
Union Applying Subclauses |
Select / Union | all 2 | Hive docs |
UNION within a FROM Clause |
Select / Union | 1 of 2 | Hive docs |
Disabling Variable Substitution |
Select / Variable Substitution | all 1 | Hive docs |
Using Variables |
Select / Variable Substitution | 21 of 24 | Hive docs |
Virtual Columns |
Select / Virtual Columns | all 3 | Hive docs |
Enhancements to Hive QL |
Select / Windowing and Analytics | all 15 | Hive docs |
Windowing and Analytics |
Select / Windowing and Analytics | all 14 | Hive docs |
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