[
https://issues.apache.org/jira/browse/CALCITE-3946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17089027#comment-17089027
]
Julian Hyde commented on CALCITE-3946:
--------------------------------------
Currently Babel does not support {{CREATE TABLE}} (or indeed any DDL). I have
no objection to it moving in that direction.
There is a more divergence between databases in DDL syntax than DML and query
syntax, so we'll have to be, well, careful if DDL statements turn out to be
ambiguous.
I notice that the {{SET}}, {{MULTISET}}, {{VOLATILE}} keywords seem to be
Teradata-specific. I have no problem with that.
The equivalent to VOLATILE in other DBs might be TEMPORARY or TRANSIENT (see
e.g.
[Snowflake|https://docs.snowflake.com/en/user-guide/tables-temp-transient.html]).
> Add parser support for MULTISET/SET and VOLATILE modifiers in CREATE TABLE
> statements
> -------------------------------------------------------------------------------------
>
> Key: CALCITE-3946
> URL: https://issues.apache.org/jira/browse/CALCITE-3946
> Project: Calcite
> Issue Type: Improvement
> Components: babel
> Affects Versions: 1.22.0
> Reporter: dasch
> Priority: Major
>
> Add support to Calcite's Babel parser for MULTISET/SET and VOLATILE modifiers
> in CREATE TABLE statements.
> The syntax for these statements is:
> CREATE TABLE [SET|MULTISET] [VOLATILE] <table_name> [IF NOT EXISTS]
> (<column_name> <data_type>, ...);
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
