StarRocks SQL Parser for Java
General SQL Parser (GSP) parses StarRocks with a dedicated, hand-tuned grammar — full AST access, offline syntax validation, formatting, rewriting, and column-level data lineage. One commercial SDK — StarRocks is available in the Java edition.
StarRocks SQL that GSP parses
CREATE DICTIONARY order_dict USING catalog1.sales.orders (
order_uuid KEY,
order_id VALUE,
order_name VALUE
) PROPERTIES(
'dictionary_warm_up'='TRUE',
'dictionary_memory_limit'='2000000000'
);Parse it in Java
import gudusoft.gsqlparser.*;
TGSqlParser parser = new TGSqlParser(EDbVendor.dbvstarrocks);
parser.sqltext = sql; // the StarRocks 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 StarRocks 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 StarRocks
- StarRocks table-type DDL
- Distribution clauses
- Materialized view DDL
- StarRocks-specific DDL that a generic MySQL parser would reject
- StarRocks keywords usable as unquoted identifiers
Beyond parsing, the same AST powers table/column extraction, validation, formatting, and column-level lineage for StarRocks.
StarRocks resources
- StarRocks syntax reference — dialect documentation
- StarRocks keyword compatibility — every keyword, and whether it can be an identifier
- StarRocks capability data (JSON) — measured construct-by-construct parse coverage, machine-readable
- Java quick start — Maven/Gradle setup and first parse
Common questions
Do I need a live StarRocks database connection to validate SQL?
No. GSP validates StarRocks 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 StarRocks grammar?
GSP uses a dedicated hand-tuned grammar for StarRocks — not a generic SQL grammar with flags. The parser recognizes 610 StarRocks keywords and knows which 607 of them can also be used as identifiers, which is exactly the kind of edge case that breaks generic parsers.
Can I use the StarRocks parser from C# / .NET?
Not currently. StarRocks is a Java-edition dialect — the .NET library ships 15 dedicated grammars and StarRocks is not one of them, so there is no C# code path for it. Everything else on this page describes the Java SDK. If you need StarRocks in .NET, email info@sqlparser.com; customer demand is how dialects get prioritized for the .NET port.
Can GSP extract column-level lineage from StarRocks SQL?
Yes. The built-in DataFlowAnalyzer produces column-level lineage, impact analysis, and call graphs from StarRocks scripts — it is the engine behind Gudu SQLFlow and the lineage integrations for DataHub and OpenMetadata.