ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Denis Magda <dma...@apache.org>
Subject Re: write-through when using SQL updates
Date Mon, 23 Apr 2018 05:16:27 GMT
If a table is created with CREATE TABLE command then:

   - Ignite creates two custom binary types (one for the key and one for
   the value) the columns will be wrapped into. A primary key defines what
   goes into the key. It happens automatically unless...
   - You define names of existing business objects the columns will be
   mapped to. Use KEY_TYPE and VALUE_TYPE parameters for that.

Read more here:
https://apacheignite-sql.readme.io/docs/create-table#section-description

--
Denis

On Sun, Apr 22, 2018 at 9:58 PM, Dmitriy Setrakyan <dsetrakyan@apache.org>
wrote:

> Denis, I get that we support it, but I still do not understand how. Given
> an SQL table in Ignite with several columns, what is the key class and what
> is the value class? Where do we document how SQL types map to key-value
> types?
>
> D.
>
> On Sun, Apr 22, 2018 at 1:43 PM, Denis Magda <dmagda@apache.org> wrote:
>
> > Dmitriy,
> >
> > According to the docs, INSERTS are transformed into cache.putIfAbsent or
> > cache.invokeAll operations:
> > https://apacheignite-sql.readme.io/docs/insert#section-description
> >
> > UPDATES are turned into cache.invokeAll all the times:
> > https://apacheignite-sql.readme.io/docs/update#section-description
> >
> > Once an SQL statement becomes a key-value operation(s) we should update
> > both RAM and a 3rd party database following a standard contract:
> > https://apacheignite.readme.io/docs/3rd-party-store
> >
> > SQL experts, please confirm my understanding is correct.
> >
> > --
> > Denis
> >
> >
> > On Sun, Apr 22, 2018 at 7:54 AM, Dmitriy Setrakyan <
> dsetrakyan@apache.org>
> > wrote:
> >
> > > Igniters,
> > >
> > > Do we support write-through to a 3rd party database when performing SQL
> > > inserts and updates? If yes, how does the mapping between SQL and
> > > CacheStore key-value API happen?
> > >
> > > D.
> > >
> >
>

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