You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ignite.apache.org by ght230 <gh...@163.com> on 2015/11/04 16:03:57 UTC

Does Ignite support SQL statement of "INSERT"?

Can I use SQL statement "INSERT" to add data to the created ignite cache? 
such as following:

insert into t1(latid, devid, devlv) values(5, 'bb', 7) 

or 

insert into t1(latid, devid, devlv) SELECT id, devid, lv FROM t2



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Does-Ignite-support-SQL-statement-of-INSERT-tp1838.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Does Ignite support SQL statement of "INSERT"?

Posted by ght230 <gh...@163.com>.

Thank you for your information!



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Does-Ignite-support-SQL-statement-of-INSERT-tp1838p1845.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Does Ignite support SQL statement of "INSERT"?

Posted by Alexey Kuznetsov <ak...@apache.org>.

Hi,

No, Ignite does not support SQL DELETE for now.
You may watch this issue: https://issues.apache.org/jira/browse/IGNITE-2294
I hope this will be available in upcoming ignite 1.8 release.

Meanwhile you could try smth. like this:
1) select _key from Tbl where _your_condition.
2) put all keys to set.
3) cache.removeAll(set)

Will this work for you?

On Tue, Nov 15, 2016 at 11:31 AM, ght230 <gh...@163.com> wrote:

> Does Ignite SQL statement support "DELETE" operation now?
>
> If not, What is the best way when I want to remove some data from cache in
> the specified condition?
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Does-Ignite-support-SQL-statement-
> of-INSERT-tp1838p8981.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>

-- 
Alexey Kuznetsov

Re: Does Ignite support SQL statement of "INSERT"?

Posted by ght230 <gh...@163.com>.

Does Ignite SQL statement support "DELETE" operation now?

If not, What is the best way when I want to remove some data from cache in
the specified condition?



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Does-Ignite-support-SQL-statement-of-INSERT-tp1838p8981.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Does Ignite support SQL statement of "INSERT"?

Posted by Dmitriy Setrakyan <ds...@apache.org>.

On Fri, Nov 6, 2015 at 9:51 AM, kevin <ke...@leonardo.com> wrote:

> Related question, would DELETE or UPDATE also be in the road map?
>

Yes, DELETE and UPDATE will come together with INSERT.


>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Does-Ignite-support-SQL-statement-of-INSERT-tp1838p1871.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>

Re: Does Ignite support SQL statement of "INSERT"?

Posted by kevin <ke...@leonardo.com>.

Related question, would DELETE or UPDATE also be in the road map?



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Does-Ignite-support-SQL-statement-of-INSERT-tp1838p1871.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Does Ignite support SQL statement of "INSERT"?

Posted by Dmitriy Setrakyan <ds...@apache.org>.

On Wed, Nov 4, 2015 at 7:33 AM, Denis Magda <dm...@gridgain.com> wrote:

> Hi,
>
> Presently only "SELECT" operator is supported by Ignite.
>

I would also add that there are several ways to efficiently ingest data
into Ignite, described here:
https://apacheignite.readme.io/docs/data-loading


> I heard that we are planning to support "INSERTS". Igniters, correct me if
> I'm wrong.
>

INSERTS are definitely on the road-map. Probably in 1.6 or 1.7 timeframe,
which should be early next year.


>
> --
> Denis
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/Does-Ignite-support-SQL-statement-of-INSERT-tp1838p1840.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>

Re: Does Ignite support SQL statement of "INSERT"?

Posted by Denis Magda <dm...@gridgain.com>.

Hi,

Presently only "SELECT" operator is supported by Ignite.

I heard that we are planning to support "INSERTS". Igniters, correct me if
I'm wrong.

--
Denis 



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Does-Ignite-support-SQL-statement-of-INSERT-tp1838p1840.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.