Quering Infinispan with Cassandra cache store

[remal]

I'm researching different solutions for the new project.

Can I use complex queries to Infinispan in distributed mode backed with Cassandra cache store after Infinispan start? Should I load all data from Cassandra to Infinispan with something code or it'll be done automatically?

PS: Sorry for my bad English...

[sannegrinovero]

Hi,

it depends on which kind of queries. When using Cassandra as a cache store it is used just as a key/value storage, so you can not use Cassandra's own features to run queries, nor you can map it on specific column organizations.

If you index your objects as mentioned on https://docs.jboss.org/author/display/ISPN/Querying+Infinispan then you can run Lucene queries (powerfull for full text but not suited for relational queries), and yes in that case the index is not stored together with the values so you can efficiently search through large collections without necessarily loading the values.