How are you creating your cache? You can absolutely use SQL with a cache that has a near cache.
> On 29 Sep 2020, at 09:16, njcstreet <njcstr...@gmail.com> wrote: > > Hi, > > I have a replicated cache that is fronted by a near cache in my client (data > loader) application. In this cache I have an integer field which is used as > a lookup key into the cache. I am using IgniteAtomicSequence to generate > this lookup key (since I believe there is no such thing as an auto increment > identity column). But when my loader starts, I need to be able to determine > the MAX lookup key to put this as the initial value for the sequence. > > What is the best way to lookup the MAX value of a field that is fronted by a > near cache, since i can’t seem to use SQL against a near cache? > > Thanks. > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/
