ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Denis Magda <dma...@apache.org>
Subject Re: DDL implementation details
Date Thu, 12 Jan 2017 20:46:19 GMT

> On Jan 12, 2017, at 12:35 PM, Dmitriy Setrakyan <dsetrakyan@apache.org> wrote:
> 
> On Thu, Jan 12, 2017 at 9:47 AM, Sergi Vladykin <sergi.vladykin@gmail.com>
> wrote:
> 
>> The xml config was only for example. We can put in this configuration
>> string cache config parameters directly like this:
>> 
>> CREATE SCHEMA "MyCacheName" WITH
>> "cacheMode=REPLICATED;atomicityMode=ATOMIC"
>> 
> 
> This approach makes sense, if it can be easily supported with H2.

What’s for affinity keys? Can we make an exception for them by defining in this part of
the statement

CREATE TABLE employee (
   id BIGINT PRIMARY KEY,
   dept_id BIGINT AFFINITY KEY,
   name VARCHAR(128),
); 

or that l

CREATE TABLE employee (
   id BIGINT PRIMARY KEY,
   dept_id BIGINT,
   name VARCHAR(128),
   CONSTRAINT affKey AFFINITY KEY(dept_id)
); 

?

—
Denis


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message