Re: What is the purpose of indexes in Cassandra table when they can not be queried?

2019-12-10 Thread Ilya Kasnacheev
Hello! I will give an alternative explanation. Even if Ignite will not go to the underlying database when doing its own SQL, it has to use underlying database to do readThrough, so underlying database should have an index on the cache key. If you only ever do writeThrough, I think you can go wit

Re: What is the purpose of indexes in Cassandra table when they can not be queried?

2019-12-05 Thread Deep
what you are facing is, limitation of Cassandra. You can't query Cassandra data if its not indexed or primary key. No matter what technology you top it off with Cassandra, you can't query without index/PK, period. The alternative is to Cache the entire table OR load it in cache and Cassandra simult

What is the purpose of indexes in Cassandra table when they can not be queried?

2019-12-03 Thread Stefan Miklosovic
Hi, I am using Cassandra Ignite integration. In this integration, one is able to provide specific "mapping" in persistence xml so a key is e.g. a primitive and value is POJO. Now, I was quite surprised (as a lot of other people too as I read more about this), that it is not possible to do SQL que