Denis The affinity key term is close to the partition key definition for MySQL: https://dev.mysql.com/doc/refman/5.7/en/partitioning-key.html
On Thu, Jan 12, 2017 at 11:46 PM, Denis Magda <dma...@apache.org> wrote: > > > 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 > > -- Sergey Kozlov GridGain Systems www.gridgain.com