Apache Impala SQL Parser Support in GSP

Explore the Apache Impala SQL Parser product page

This page documents the SQL syntax support for Apache Impala in the General SQL Parser.

Syntax Coverage Corpus

GSP tests Impala syntax against 47 documented constructs grouped into 24 categories, each cross-referenced to the documentation that defines it (47 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 Impala 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	46 of 47 (98%)	288 of 290 (99%)
SELECT (queries)	12 of 12 (100%)	75 of 75 (100%)
DML (INSERT / UPDATE / DELETE / MERGE)	4 of 4 (100%)	43 of 43 (100%)
Stored procedures	1 of 1 (100%)	1 of 1 (100%)

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 47 constructs

Construct	Category	Parses	Specified in
ALTER DATABASE	ALTER	all 2	Impala docs
ALTER TABLE	ALTER	all 46	Impala docs
ALTER VIEW	ALTER	all 6	Impala docs
COMMENT	COMMENT	all 1	Impala docs
COMPUTE STATS	COMPUTE STATS	all 5	Impala docs
CREATE DATABASE	CREATE	all 2	Impala docs
CREATE FUNCTION	CREATE	all 1	Impala docs
CREATE ROLE	CREATE	all 1	Impala docs
CREATE TABLE	CREATE	all 27	Impala docs
CREATE VIEW	CREATE	all 7	Impala docs
DELETE	DELETE	all 12	Impala docs
DESCRIBE	DESCRIBE	all 7	Impala docs
DROP DATABASE	DROP	all 2	Impala docs
DROP FUNCTION	DROP	all 1	Impala docs
DROP ROLE	DROP	all 1	Impala docs
DROP STATS	DROP	all 3	Impala docs
DROP TABLE	DROP	all 1	Impala docs
DROP VIEW	DROP	all 2	Impala docs
EXPLAIN	EXPLAIN	all 3	Impala docs
GRANT	GRANT	all 2	Impala docs
INSERT	INSERT	all 23	Impala docs
INVALIDATE METADATA	INVALIDATE METADATA	all 1	Impala docs
LOAD DATA	LOAD DATA	all 4	Impala docs
Optimizer Hints	Optimizer Hints	all 3	Impala docs
REFRESH	REFRESH	all 3	Impala docs
REFRESH AUTHORIZATION	REFRESH	all 1	Impala docs
REFRESH FUNCTIONS	REFRESH	all 1	Impala docs
REVOKE	REVOKE	all 2	Impala docs
DISTINCT	SELECT	all 4	Impala docs
GROUP BY	SELECT	all 3	Impala docs
HAVING	SELECT	all 1	Impala docs
Joins in	SELECT	all 19	Impala docs
LIMIT	SELECT	all 9	Impala docs
OFFSET	SELECT	all 2	Impala docs
ORDER BY	SELECT	all 12	Impala docs
Subqueries	SELECT	all 9	Impala docs
TABLESAMPLE	SELECT	all 4	Impala docs
UNION	SELECT	all 6	Impala docs
WITH	SELECT	all 2	Impala docs
SET	SET	5 of 7	Impala docs
SHOW	SHOW	all 23	Impala docs
SHUTDOWN	SHUTDOWN	all 3	Impala docs
TRUNCATE TABLE	TRUNCATE	all 2	Impala docs
UPDATE	UPDATE	all 7	Impala docs
UPSERT	UPSERT	all 3	Impala docs
USE	USE	all 1	Impala docs
VALUES	VALUES	all 3	Impala docs

Key Features Supported

• Standard SQL operations (SELECT, INSERT, UPDATE, DELETE)
• Impala-specific functions and data types
• Hadoop ecosystem integration
• Window functions and analytical queries
• Parquet and other columnar formats
• Real-time query processing