[
https://issues.apache.org/jira/browse/CALCITE-707?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16248274#comment-16248274
]
Julian Hyde commented on CALCITE-707:
-------------------------------------
I am actively working on this and CALCITE-1991, creating a new "server" module.
You can see work in progress in
https://github.com/julianhyde/calcite/tree/707-ddl.
> Built-in support for simple DDL statements
> ------------------------------------------
>
> Key: CALCITE-707
> URL: https://issues.apache.org/jira/browse/CALCITE-707
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
>
> I would like Calcite to support simple DDL.
> DDL (and other commands such as KILL STATEMENT) make it possible to do a wide
> range of operations over a REST or JDBC interface. We can't expect everything
> do be done locally, using Java method calls.
> I expect that projects that use Calcite will define their own DDL. (In fact
> Drill and Phoenix already do; see PHOENIX-1706.) Those projects are very
> likely to have their own variations on CREATE TABLE etc. so they will want to
> extend the parser. What I did in Phoenix (which was in turn adapted from
> Drill) is a model that other projects can follow.
> But the base Calcite project should have CREATE TABLE, DROP TABLE, CREATE
> SCHEMA, DROP SCHEMA, CREATE [ OR REPLACE ] VIEW etc. There will be an AST
> (extending SqlNode) for each of these commands, and a command-handler. Each
> project that uses Calcite could extend those
> ASTs, but it would be fine if it built its own AST and command-handler.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
