Yury Gerzhedovich created IGNITE-16591:
------------------------------------------

             Summary: DDL syntax COLOCATE BY
                 Key: IGNITE-16591
                 URL: https://issues.apache.org/jira/browse/IGNITE-16591
             Project: Ignite
          Issue Type: Improvement
          Components: sql
            Reporter: Yury Gerzhedovich


Add COLOCATED BY for CREATE TABLE syntaxis:
Colocate by could contains list of  columns (one or more).
E.g.:

 
{code:java}
CREATE TABLE OrderItems (
  order_item_id      INT,
  order_id       INT,
  department_id      INT,
  amount           INT,
  PRIMARY KEY (order_item_id, order_id, department_id)
)
COLOCATE BY (order_id, department_id)
{code}
 



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

Reply via email to