Hi, Ignite SQL queries work over the data located on-heap, off-heap or swap. If a part of the data is completely removed from a cache due to an eviction policy then SQL engine won't be able to read this missing data from an underlying CacheStore. Read-through is supported only for get()/getAll() like operations.
Actually you can enable the swap space [1] where the data will be evicted and keep using SQL. Will this work for you? As per the cache metrics what do you mean saying that they don't work for the client. Please elaborate more on this. Finally, please properly subscribe to the user list (this way we will not have to manually approve your emails). All you need to do is send an email to “ [email protected]” and follow simple instructions in the reply. [1] https://apacheignite.readme.io/docs/off-heap-memory#swap-space -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Reading-data-using-SQL-queries-tp3593p3609.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
