Mailing-List: contact issues-help@ignite.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@ignite.apache.org
Date: Sat, 6 Aug 2016 07:45:20 +0000 (UTC)
From: "Alexander Paschenko (JIRA)" <jira@apache.org>
To: issues@ignite.apache.org
Message-ID: <JIRA.12924346.1451122476000.241465.1470469520761@Atlassian.JIRA>
In-Reply-To: <JIRA.12924346.1451122476000@Atlassian.JIRA>
References: <JIRA.12924346.1451122476000@Atlassian.JIRA> <JIRA.12924346.1451122476682@arcas>
Subject: [jira] [Commented] (IGNITE-2294) Implement SQL DML (insert, update,
 delete) clauses.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Sat, 06 Aug 2016 07:45:22 -0000


    [ https://issues.apache.org/jira/browse/IGNITE-2294?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15410532#comment-15410532 ] 

Alexander Paschenko commented on IGNITE-2294:
---------------------------------------------

1. You're not quite right. {{addBatch}} does not assign params by itself (and does not take any args at all), but rather tells driver that a new row has to be added to the batch, and for it the current set of values is copied. You set params by calling series of, say, {{setInt(column, value)}} (or whatever the type of param is), then call {{addBatch}}, and so forth, for each of the rows.

2. Could you please elaborate on difference in semantics?

We could of course turn data streamer on by setting connection string param, but still there's the question: how and when do we flush then? By forcing the user to set auto flush timeout? (Sounds like an option to me.) I don't think that it would be a good idea to introduce our "own" SQL statements for data streamer flush, and can't come up with how we could let the driver and cache know about the flush otherwise.

> Implement SQL DML (insert, update, delete) clauses.
> ---------------------------------------------------
>
>                 Key: IGNITE-2294
>                 URL: https://issues.apache.org/jira/browse/IGNITE-2294
>             Project: Ignite
>          Issue Type: Wish
>            Reporter: Sergi Vladykin
>            Assignee: Alexander Paschenko
>             Fix For: 1.7
>
>
> We need to add parsing for all the listed SQL commands and translate them into respective cache operations (putIfAbstent, put, remove).


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)