Apache Calcite能够很好地解析和处理 DML 语句解析，但似乎无法解析任何 DDL 语句(CREATE TABLE、ALTER TABLE、DROP TABLE 等)。

public static SqlNode parse(String query) {
    SqlParser.Config sqlParserConfig = SqlParser.config();
    SqlParser parser = SqlParser.create(query, sqlParserConfig);

    try {
        return parser.parseStmt();
    } catch (SqlParseException e) {
        throw new RuntimeException(e);
    }
}

当我尝试解析 CREATE TABLE 语句时，它给出了以下错误消息。

org.apache.calcite.sql.parser.SqlParseException: Incorrect syntax near the keyword 'CREATE' at line 1, column 1.
Was expecting one of:
    "ABS" ...
    "ALTER" ...
    "ARRAY" ...
    "AVG" ...
    "CALL" ...
    "CARDINALITY" ...
    "CASE" ...
    "CAST" ...
    "CEIL" ...
    "CEILING" ...
    "CHAR" ...
    "CHAR_LENGTH" ...
    "CHARACTER_LENGTH" ...
    "CLASSIFIER" ...
    "COALESCE" ...
    "COLLECT" ...
    "CONVERT" ...
    "COUNT" ...
    "COVAR_POP" ...
    "COVAR_SAMP" ...
    "CUME_DIST" ...
    //省略

发现是缺少合适的解析工厂。


SqlParser.Config sqlParserConfig = SqlParser.config();
sqlParserConfig.withParserFactory(SqlDdlParserImpl.FACTORY);
SqlParser parser = SqlParser.create(query, sqlParserConfig);

SqlDdlParserImpl在calcite-server模块

<dependency>
    <groupId>org.apache.calcite</groupId>
    <artifactId>calcite-server</artifactId>
    <version>1.35.0</version>
</dependency>