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.
