[
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 for some reason, we put here {{PRIMARY_ZONE and
}}{{STORAGE_PROFILE. Both parameters use underscore to separate complex name
and it looks not so SQL-like style where we usualy use space between lexis.}}
{{Let's move it as part of common syntax and remove *PRIMARY* word , so it will
looks like a}}
{code:java}
... [COLOCATE [ BY ] <column_name_or_list>] [ ZONE <zone_name> ] [ STORAGE
PROFILE <profile_name> ] [ WITH <key_values_pair>]{code}
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 for some reason, we put here {{PRIMARY_ZONE and
}}{{STORAGE_PROFILE. Both parameters use underscore to separate complex name
and it looks not so SQL-like style where we usualy use space between lexis.}}
{{Let's move it as part of common syntax and remove *PRIMARY* word , so it will
looks like a}}
{code:java}
{code}
{{... [COLOCATE [ BY ] <column_name_or_list>] [ ZONE <zone_name> ] [ STORAGE
PROFILE <profile_name> ] [ WITH <key_values_pair>]}}
> 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 for some reason, we put here
> {{PRIMARY_ZONE and }}{{STORAGE_PROFILE. Both parameters use underscore to
> separate complex name and it looks not so SQL-like style where we usualy use
> space between lexis.}}
> {{Let's move it as part of common syntax and remove *PRIMARY* word , so it
> will looks like a}}
> {code:java}
> ... [COLOCATE [ BY ] <column_name_or_list>] [ ZONE <zone_name> ] [ STORAGE
> PROFILE <profile_name> ] [ WITH <key_values_pair>]{code}
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
