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
>