[
https://issues.apache.org/jira/browse/IGNITE-23353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Iurii Gerzhedovich updated IGNITE-23353:
----------------------------------------
Description:
As of now for CREATE TABLE syntax we have a section *`WITH`* with non-specified
key-value pairs of parameters. It is flexible and convenient to extend syntax
by some extension, but right now we have only two options {{*PRIMARY_ZONE* and
{*}STORAGE_PROFILE{*}. Both parameters use an underscore to separate complex
names and it looks not so SQL-like style where we usually use space between
lexis.}}
{{The proposal is the following:}}
{{1. Remove *WITH* part.}}
{{2. Make}}{{ both parameters as part of the common syntax and remove the
*PRIMARY* word, so it will look like a:}}
{code:java}
... [COLOCATE [ BY ] <column_name_or_list>] [ ZONE <zone_name> ] [ STORAGE
PROFILE <profile_name> ]{code}
In case in the future will require additional flexible parameters *WITH*
section can be returned.
was:
As of now for CREATE TABLE syntax we have a section *`WITH`* with non-specified
key-value pairs of parameters. It is flexible and convenient to extend syntax
by some extension, but right now we have only two options {{*PRIMARY_ZONE* and
{*}STORAGE_PROFILE{*}. Both parameters use an underscore to separate complex
names and it looks not so SQL-like style where we usually use space between
lexis.}}
{{Proposal is the following:}}
{{1. Remove *WITH* part.}}
{{2. Make}}{{{} both parameters as part of the common syntax and remove the
*PRIMARY* word, so it will look like a{}}}{{{{}}{}}}
{code:java}
... [COLOCATE [ BY ] <column_name_or_list>] [ ZONE <zone_name> ] [ STORAGE
PROFILE <profile_name> ]{code}
In case in the future will require additional non specified-parameters *WITH*
section can be return back.
> Sql. improve CREATE TABLE syntax
> --------------------------------
>
> Key: IGNITE-23353
> URL: https://issues.apache.org/jira/browse/IGNITE-23353
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Iurii Gerzhedovich
> Priority: Major
> Labels: ignite-3
>
> As of now for CREATE TABLE syntax we have a section *`WITH`* with
> non-specified key-value pairs of parameters. It is flexible and convenient to
> extend syntax by some extension, but right now we have only two options
> {{*PRIMARY_ZONE* and {*}STORAGE_PROFILE{*}. Both parameters use an underscore
> to separate complex names and it looks not so SQL-like style where we usually
> use space between lexis.}}
> {{The proposal is the following:}}
> {{1. Remove *WITH* part.}}
> {{2. Make}}{{ both parameters as part of the common syntax and remove the
> *PRIMARY* word, so it will look like a:}}
> {code:java}
> ... [COLOCATE [ BY ] <column_name_or_list>] [ ZONE <zone_name> ] [ STORAGE
> PROFILE <profile_name> ]{code}
>
> In case in the future will require additional flexible parameters *WITH*
> section can be returned.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
