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 <dma...@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. >
