[
https://issues.apache.org/jira/browse/IGNITE-23353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Iurii Gerzhedovich reassigned IGNITE-23353:
-------------------------------------------
Assignee: Iurii Gerzhedovich
> 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
>
> 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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
