Hi, Is there any way to make sure that SQL executed on cache gets executed only on the node where data is present? One way could be submit the the task on affinity key to get the data. But is doesn't seem good option.
My case is I am already submitting a ignite runnable task on my affinity id. Inside this task I am querying multiple caches. And the data I am querying for is present on the node where the task is executing. How can I make sure that this SQL gets executed only on current node? Thanks, Prasad
