SQL dialect

Apache Impala SQL Parser for Java and .NET

General SQL Parser (GSP) parses Apache Impala with a dedicated, hand-tuned grammar — full AST access, offline syntax validation, formatting, rewriting, and column-level data lineage . One commercial SDK, 38 dialects, Java and .NET.

264
Apache Impala keywords recognized by the grammar
252
keywords the parser also accepts as identifiers
198
Apache Impala test SQL files in the regression corpus
Weekly
release cadence — dialect fixes ship in days

Example

Apache Impala SQL that GSP parses

COMPUTE STATS sales_data;
DROP TABLE staging_sales PURGE;

Parse it in Java

import gudusoft.gsqlparser.*;

TGSqlParser parser = new TGSqlParser(EDbVendor.dbvimpala);
parser.sqltext = sql; // the Apache Impala SQL above
if (parser.parse() == 0) {
    System.out.println(parser.sqlstatements.size() + " statement(s) parsed");
} else {
    System.out.println(parser.getErrormessage());
}

The .NET edition exposes the same API in C# — see the C# quick start.

Coverage

What GSP handles in Apache Impala

Beyond parsing, the same AST powers table/column extraction, validation, formatting, and column-level lineage for Apache Impala.

Actively maintained

Recent Apache Impala parser updates

Full history in the release notes.

Go deeper

Apache Impala resources

Common questions

Do I need a Apache Impala database connection to validate SQL?

No. GSP validates Apache Impala syntax completely offline. You get error line and column positions, the offending token, and a hint — with no server, driver, or credentials involved.

How complete is the Apache Impala grammar?

GSP uses a dedicated hand-tuned grammar for Apache Impala — not a generic SQL grammar with flags. The parser recognizes 264 Apache Impala keywords and knows which 252 of them can also be used as identifiers, which is exactly the kind of edge case that breaks generic parsers.

Can I use the Apache Impala parser from C# / .NET?

Yes. The .NET edition (NuGet package gudusoft.gsqlparser, .NET Standard 2.0) exposes the same API surface as the Java edition, so every Apache Impala parsing feature on this page works in C# and VB.NET.

Can GSP extract column-level lineage from Apache Impala SQL?

Yes. The built-in DataFlowAnalyzer produces column-level lineage, impact analysis, and call graphs from Apache Impala scripts — it is the engine behind Gudu SQLFlow and the lineage integrations for DataHub and OpenMetadata.