[
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}
<zone name> should be just a identifier
<profile_name> should be a string
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.}}
{{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}
<zone name> should be just a identifier
<profile_name> can be either identifier or string ( let's check if is it
require).
In case in the future will require additional flexible parameters *WITH*
section can be returned.
> 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
> Assignee: Iurii Gerzhedovich
> Priority: Major
> Labels: ignite-3
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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}
> <zone name> should be just a identifier
> <profile_name> should be a string
> 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)
