ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dmitriy Setrakyan <dsetrak...@apache.org>
Subject Re: Does ignite support UPDATE/DELETE sql
Date Thu, 14 Jul 2016 05:53:28 GMT
We are currently working on adding insert/update/delete commands to Ignite.
Here is the ticket you can follow:

https://issues.apache.org/jira/browse/IGNITE-2294

Thanks,
D.

On Thu, Jul 14, 2016 at 6:58 AM, Denis Magda <dmagda@gridgain.com> wrote:

> Hi,
>
> Please properly subscribe to the Ignite's user list. Refer to this page for
> details - https://ignite.apache.org/community/resources.html#ask
>
> See my answers inline.
>
>
> zhaojun08 wrote
> > HI ALL,
> >
> > I am new to ignite, and I have a few questions to confirm.
> >
> > 1. I want to use ignite to store RDBMS in MEM. Table in RDBMS have many
> > rows, does ignite store every row as a Java object, like the "Person"
> > object in docs? And is it the only way to store a row in Ignite?
> /
> > Yes, Apache Ignite is an in-memory key-value store meaning that for every
> > key there should be a corresponding value. A key-value tuple will
> > correspond to a row from your RDBMS store.
> /
> >
> > 2. I notice that "Person" class implements Serializable, does it mean
> > every row record stores in ignite in Serialization format? If so, will
> the
> > Serialization degrade the select performance, and the reason for
> > Serialization?
> /
> > Objects are stored in a serialized form in memory. However it doesn't
> mean
> > that JDK serialization techniques are used to prepare an object for
> > storage. In fact Ignite uses its own BinaryMarshaller (serializer) that
> > has good performance characteristics -
> > https://apacheignite.readme.io/docs/binary-marshaller
> /
> >
> > 3. I have store RDBMS in Ignite, can I update specific row record using
> > UPDATE/DELETE sql statement to alter the table?
> /
> > This kind of queries is not supported right know. You have to update
> > caches with methods like cache.put, cache.putAll, cache.invoke, etc.
> /
> >
> /
> > If you need to pre-load data from RDBMS then you can rely on  one of the
> > pre-loading strategies -
> https://apacheignite.readme.io/docs/data-loading.
> > This topic should be useful for you as well -
> > https://apacheignite.readme.io/docs/persistent-store
> /
> >
> > --
> > Denis
> >
> > Many Thanks!
>
>
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Does-ignite-support-UPDATE-DELETE-sql-tp6290p6292.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>

Mime
View raw message