Re: DDL implementation details

[Denis Magda]

> On Jan 12, 2017, at 12:35 PM, Dmitriy Setrakyan <dsetrak...@apache.org> wrote:
> 
> On Thu, Jan 12, 2017 at 9:47 AM, Sergi Vladykin <sergi.vlady...@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