Re: How to parse sql of DDL

[xiao cai]

Hi Liya：
Thanks for your suggestion！


Here is the demo i ran using SqlParser:


--------------
String sql = "ALTER TABLE `test`.`mysql_sink_test_1` ADD COLUMN `col_for_test` 
varchar(255) NULL AFTER `col_binary_1`;
 SqlParser.Config mysqlConfig = 
SqlParser.configBuilder().setLex(Lex.MYSQL).build();
 SqlParser sqlParser = SqlParser.create(sql.toLowerCase(), mysqlConfig);
 SqlNode sqlNode = sqlParser.parseStmt();
--------------


Then I received the following error message：


---------------------
org.apache.calcite.sql.parser.SqlParseException: Encountered "table" at line 1, 
column 7.
Was expecting one of:
    "SESSION" ...
    "SYSTEM" ...
at 
org.apache.calcite.sql.parser.impl.SqlParserImpl.convertException(SqlParserImpl.java:364)
at 
org.apache.calcite.sql.parser.impl.SqlParserImpl.normalizeException(SqlParserImpl.java:149)
at org.apache.calcite.sql.parser.SqlParser.handleException(SqlParser.java:148)
at org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:163)
at org.apache.calcite.sql.parser.SqlParser.parseStmt(SqlParser.java:188)
———————————






 原始邮件 
发件人: Fan Liya<liya.fa...@gmail.com>
收件人: dev<dev@calcite.apache.org>
发送时间: 2020年11月4日(周三) 10:40
主题: Re: How to parse sql of DDL


Hi Xiao, It's hard to diagnose the problem without seeing your code. My 
suggestion is that you can debug some test cases in our code base (related to 
SqlParser), and check how it works. Best, Liya Fan On Wed, Nov 4, 2020 at 10:34 
AM xiao cai <flin...@163.com> wrote: > Hi > I just want to konw how to parse 
the sql statement of DDL. I had use > SqlParser to do this, but it was failed. 
> Is someone can help me , thank you very mush. > > > Best xiao.