Vertica SQL Parser for Java

Vertica SQL that GSP parses

CREATE PROJECTION sales_proj AS
SELECT id, region, amt FROM sales
ORDER BY region
SEGMENTED BY HASH(id) ALL NODES;

Parse it in Java

import gudusoft.gsqlparser.*;

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

Java edition only. The .NET library has no Vertica grammar, so this dialect cannot be parsed from C# or VB.NET. See the .NET SQL Parser SDK for the dialects it does cover.

What GSP handles in Vertica

• CREATE PROJECTION ... AS SELECT
• Flex tables
• Access policies
• Resource pools
• EXPORT TO VERTICA

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

Recent Vertica parser updates

• 2026-06-02 [Vertica] Parse AUTO_INCREMENT column attribute
• 2026-05-08 [Vertica] Support AND filter and WHERE in MERGE clauses
• 2026-04-05 [Vertica] Parse AS SELECT subquery in CREATE PROJECTION

Full history in the release notes.