Iurii Gerzhedovich created IGNITE-23353:
-------------------------------------------

             Summary: 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


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>]}}

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to