You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Prasad Bhalerao <pr...@gmail.com> on 2018/07/06 01:51:40 UTC

Aviod distributes query in case of collocated data

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

Re: Aviod distributes query in case of collocated data

Posted by Evgenii Zhuravlev <e....@gmail.com>.
SqlFieldsQuery.setLocal:
https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/cache/query/SqlFieldsQuery.html#setLocal-boolean-

2018-07-06 4:51 GMT+03:00 Prasad Bhalerao <pr...@gmail.com>:

> 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
>