Thanks, Danny
I will have a try, but it seems challenging, i thought… Regards, Trista Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 09/26/2019 14:19,Danny Chan<yuzhao....@gmail.com> wrote: 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 <panj...@apache.org>,写道: @Danny Chan Thanks Danny, is there any document or test for me to learn `specific convention` more? Regards, Trista Juan Pan panj...@apache.org Juan Pan(Trista), Apache ShardingSphere On 09/26/2019 12:02,Danny Chan<yuzhao....@gmail.com> 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 <amaliu...@apache.org>,写道: 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 <zabe...@gmail.com> 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 <mgelb...@apache.org> 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 <panj...@apache.org> 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 panj...@apache.org Juan Pan(Trista), Apache ShardingSphere