Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id AF0B4200B54 for ; Thu, 14 Jul 2016 07:54:11 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id AD77E160A6E; Thu, 14 Jul 2016 05:54:11 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id CF7E9160A6A for ; Thu, 14 Jul 2016 07:54:10 +0200 (CEST) Received: (qmail 24024 invoked by uid 500); 14 Jul 2016 05:54:09 -0000 Mailing-List: contact user-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ignite.apache.org Delivered-To: mailing list user@ignite.apache.org Received: (qmail 24015 invoked by uid 99); 14 Jul 2016 05:54:09 -0000 Received: from mail-relay.apache.org (HELO mail-relay.apache.org) (140.211.11.15) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 Jul 2016 05:54:09 +0000 Received: from mail-qk0-f175.google.com (mail-qk0-f175.google.com [209.85.220.175]) by mail-relay.apache.org (ASF Mail Server at mail-relay.apache.org) with ESMTPSA id 577061A00E0 for ; Thu, 14 Jul 2016 05:54:09 +0000 (UTC) Received: by mail-qk0-f175.google.com with SMTP id o67so64356051qke.1 for ; Wed, 13 Jul 2016 22:54:09 -0700 (PDT) X-Gm-Message-State: ALyK8tLXv9oG1wg7jZHUo53HQTN0CpzfOTR88uIq0Z9MQ+UVQikdxCBeOe1QW3DXCXCFlAws/ah13AF94JdjG9/Q X-Received: by 10.55.24.35 with SMTP id j35mr14612939qkh.120.1468475647914; Wed, 13 Jul 2016 22:54:07 -0700 (PDT) MIME-Version: 1.0 Received: by 10.140.81.9 with HTTP; Wed, 13 Jul 2016 22:53:28 -0700 (PDT) In-Reply-To: <1468468724259-6292.post@n6.nabble.com> References: <1468461407050-6290.post@n6.nabble.com> <1468468724259-6292.post@n6.nabble.com> From: Dmitriy Setrakyan Date: Thu, 14 Jul 2016 08:53:28 +0300 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: Does ignite support UPDATE/DELETE sql To: user Content-Type: multipart/alternative; boundary=001a113c1a9c5b1edc0537922199 archived-at: Thu, 14 Jul 2016 05:54:11 -0000 --001a113c1a9c5b1edc0537922199 Content-Type: text/plain; charset=UTF-8 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 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. > --001a113c1a9c5b1edc0537922199 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
We are currently working on adding insert/update/delete co= mmands to Ignite. Here is the ticket you can follow:


Thanks,<= /div>
D.

On Thu, Jul 14, 2016 at 6:58 AM, Denis Magda <<= a href=3D"mailto:dmagda@gridgain.com" target=3D"_blank">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 man= y
> rows, does ignite store every row as a Java object, like the "Per= son"
> 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 ev= ery
> 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, doe= s 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= 9;t mean
> that JDK serialization techniques are used to prepare an object for > storage. In fact Ignite uses its own BinaryMarshaller (serializer) tha= t
> has good performance characteristics -
> https://apacheignite.readme.io/docs/binar= y-marshaller
/
>
> 3. I have store RDBMS in Ignite, can I update specific row record usin= g
> 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=C2=A0 one= of the
> pre-loading strategies - https://apacheignite.r= eadme.io/docs/data-loading.
> This topic should be useful for you as well -
> https://apacheignite.readme.io/docs/persi= stent-store
/
>
> --
> Denis
>
> Many Thanks!





--
View this message in context: http://apache-ignite-users.70518.x6.nabble.c= om/Does-ignite-support-UPDATE-DELETE-sql-tp6290p6292.html
Sent from the Apache Ignite Users m= ailing list archive at Nabble.com.

--001a113c1a9c5b1edc0537922199--