SqlQuery with Cassandra cache

[Kenan Dalley <ke...@gm.com>]

Can someone explain to me what I'm doing wrong?  I'm trying to query an
Ignite cache backed up by Cassandra, but I keep getting the following error. 
Can a SqlQuery be created against a C*-backed cache?  I would think so, but
not sure exactly how and there are no good examples that I can find in the
wild.

Error
Test class (SpringBootApp)
AppConfig
cassandra-ignite.xml
persistence-settings.xml
connection-settings.xml
Test1Key class
Test1 class
C* table




--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: SqlQuery with Cassandra cache

[Kenan Dalley <ke...@gm.com>]

I was starting to think that was the case.  Thanks for the help and verifying
that for me, Val.



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: SqlQuery with Cassandra cache

[vkulichenko <va...@gmail.com>]

Hi Kenan,

SQL queries are executed against the data that is in memory. Read-though
semantics works for key-based access only. If you need to query data that is
both in memory and on disk, I'd recommend to take a look at Ignite native
persistence:
https://apacheignite.readme.io/docs/distributed-persistent-store

-Val



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/