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 > > > > > > > > >
