ClickHouse SQL Parser for Java

ClickHouse SQL that GSP parses

CREATE TABLE hits (dt DateTime, uid UInt64)
ENGINE = MergeTree()
PARTITION BY toYYYYMM(dt)
ORDER BY (dt, uid);

Need us to check your own ClickHouse SQL? Send a sample.

Parse it in Java

import gudusoft.gsqlparser.*;

TGSqlParser parser = new TGSqlParser(EDbVendor.dbvclickhouse);
parser.sqltext = sql; // the ClickHouse 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 ClickHouse 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 ClickHouse

• ENGINE = MergeTree clauses
• PREWHERE filtering
• ARRAY JOIN
• LIMIT BY and SAMPLE
• Materialized views ON CLUSTER

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

Recent ClickHouse parser updates

• 2026-08-18 [ClickHouse] Parse Map literals, two-argument CAST, dotted nested column names, and tuple element access (a.2)
• 2026-08-18 [ClickHouse] Parse ALTER TABLE UPDATE/DELETE IN PARTITION, INSERT ... FORMAT with inline data, and PARALLEL WITH
• 2026-08-17 [ClickHouse] Parse == comparison, INTERSECT DISTINCT, GROUPING SETS, ASOF/ANY join order, WITH FILL STALENESS/INTERPOLATE, VALUES table literals

Full history in the release notes.