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

Posted to user@ignite.apache.org by vkulichenko <va...@gmail.com> on 2016/04/01 00:32:04 UTC

Re: getAndRemove type functionality using queries

Hi,

Currently there is no direct way to do this, because SQL queries support
only SELECT statements. But you can use it to find the entry (or entries)
you want to remove, and then use IgniteCache.remove(K key) to actually
delete the value(s). If you don't want to remove in case it was updated in
the middle of the process, you can use the version of the method that also
takes the old value to compare with: remove(K key, V oldVal). Here, if you
provide the value that was returned by the query, the remove will be
successful only if the value was not changed.

Will this work for you?

-Val



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/getAndRemove-type-functionality-using-queries-tp3818p3831.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.