The ElasticsearchTableScan is a good start to show how it transfers the elastic nodes from Convention.NONE to ElasticsearchRel.CONVENTION [1]
[1] https://github.com/apache/calcite/blob/c9adf94b0e07f2e9108ef4d1f2ee28c3e42063b3/elasticsearch/src/main/java/org/apache/calcite/adapter/elasticsearch/ElasticsearchTableScan.java#L79 Best, Danny Chan 在 2019年9月26日 +0800 PM12:13，Juan Pan <[email protected]>，写道： > @Danny Chan > > > > Thanks Danny, is there any document or test for me to learn `specific > convention` more? > > > Regards, > Trista > > > Juan Pan > > > [email protected] > Juan Pan(Trista), Apache ShardingSphere > > > On 09/26/2019 12:02，Danny Chan<[email protected]> wrote： > @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 > > > >
