Remove a full collection result from an remote query

[manuelfranqueira]

Hi guys,

I can now do a remote query with Hotrod, but I need to remove a collection at once.

I have the following code which return a list of instances:

Query query = qf.from(datagrid.Teste.class)

               .having("title").like("%" + title + "%").toBuilder()

               .build();

List<Teste> results = query.list();

How can I remove the results of a query like this all at once?

Thanks again for the support,

Manuel Franqueira

[anistor]

Hi Manuel,

we do not have a delete by query feature ATM, but if you would be interested you could add a JIRA. We'll discuss the infinispan roadmap in February and this kind of community feedback will be very helpful.

Thanks,

Adrian

[manuelfranqueira]

There is any alternative to this at this moment?

Thanks,

Manuel

[nadirx]

Once ISPN-5013 Stored Script Execution by tristantarrant · Pull Request #3162 · infinispan/infinispan · GitHub is in you will be able to do it via a Stored Script

[rvansa]

The best way to remove multiple entries now is to use asynchronous operations (cache.removeAsync(...) or issue those sync removes from your own threadpool).

Note that there's no option to do this neither in embedded mode directly, unless you use transactions (then all the removes are executed in one pair of commands).