@Rui Wang, Yes, I wrote the Flink-sql-parser module it did support insert grammar well.
@Juan Pan you need the converter rules to convert all the nodes to specific convention you want, also specify the desired convention in the trait set of your planing program. Best, Danny Chan 在 2019年9月26日 +0800 AM6:04，Rui Wang <[email protected]>，写道： > Another data point is both BeamSQL and FlinkSQL support DDL by an extensive > way (and I believe it works through Avitica as well). > > BeamSQL: [1] > FlinkSQL: [2] > > > Calcite allows add customized DDL in parser and also in implementation > schema is accessible. > > [1]: > https://github.com/apache/beam/blob/master/sdks/java/extensions/sql/src/main/codegen/includes/parserImpls.ftl#L149 > [2]: > https://github.com/apache/flink/blob/master/flink-table/flink-sql-parser/src/main/codegen/data/Parser.tdd#L430 > > -Rui > > On Wed, Sep 25, 2019 at 2:54 PM Stamatis Zampetakis <[email protected]> > wrote: > > > Hi Trista, > > > > I think the server module is doing what you are asking for. Have a look in > > ServerTest [1]. > > As Gelbana mentioned the implementation is based on implementations of the > > ModifiableTable interface. > > > > Best, > > Stamatis > > > > [1] > > > > https://github.com/apache/calcite/blob/master/server/src/test/java/org/apache/calcite/test/ServerTest.java > > > > On Wed, Sep 25, 2019 at 11:29 PM Mohamed Mohsen <[email protected]> > > wrote: > > > > > I haven't done that before but I would start investigating from this > > > interface [1]. Please share your experience if you get this done. > > > > > > [1] org.apache.calcite.schema.ModifiableTable > > > > > > > > > On Wed, Sep 25, 2019 at 2:00 PM Juan Pan <[email protected]> wrote: > > > > > > > Hi everyone, > > > > > > > > > > > > Thanks for your attention. I want to know the following description is > > > > right or not? > > > > > > > > > > > > "Modification has only been worked on for JDBC tables, not for any > > custom > > > > tables currently.” > > > > > > > > > > > > Query SQL on custom table is ok, so i am wondering whether i can > > execute > > > > `update/insert/delete` SQL through Calcite on custom tables. > > > > > > > > > > > > Can anyone give me some ideas? > > > > > > > > > > > > Really thanks for your help. > > > > > > > > > > > > Regards, > > > > Trista > > > > > > > > > > > > > > > > > > > > > > > > > > > > Juan Pan > > > > > > > > > > > > [email protected] > > > > Juan Pan(Trista), Apache ShardingSphere > > > > > > > > > > > > >
