You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by "smilehong (洪利平)" <sm...@tencent.com> on 2016/02/29 08:52:55 UTC
How can I only get the local data
Hi, all
when I use the “select * from XX where XX” in ignite, how can I only get the local data ? because it obtain data on all nodes default. And I have configure the cache modes is partitioned mode.
Thank you very much!
Re: 答复: How can I only get the local data(Internet mail)
Posted by Dmitriy Setrakyan <ds...@apache.org>.
On Mon, Feb 29, 2016 at 5:27 PM, smilehong(洪利平) <sm...@tencent.com>
wrote:
> thank you, and you means that use Query.setLocal(true) can achieve this
> goal ?
>
As Denis suggested, using SQL directly is the best option, as the query
will be broadcast within the cluster automatically.
If you need to execute a broadcast compute closure instead, then
Query.setLocal(true) is the best option to do so, as it will execute only
on the node that is executing the computation.
>
>
> *发件人:* Dmitriy Setrakyan [mailto:dsetrakyan@apache.org]
> *发送时间:* 2016年3月1日 5:30
> *收件人:* user
> *主题:* Re: How can I only get the local data(Internet mail)
>
>
>
> I think the answer is to use Query.setLocal(true) flag which will return
> correct results on the stable topology. The issue with changing topology is
> being addressed right now and should become part of the next release.
>
>
>
> D.
>
>
>
> On Mon, Feb 29, 2016 at 3:11 AM, Denis Magda <dm...@gridgain.com> wrote:
>
> Hi,
>
> Presently there is no a reliable way to execute a SQL query over local
> collocated data.
> Even if you set Query.setLocal to "true" there is a chance that you will
> get incomplete result set if re-partitioning happened at some point of the
> query execution.
>
> However, it's planned to support the feature that will execute a query on
> a specific machine if it's know that all the data is located there.
> Igniters, have we already created a ticket for this feature?
>
> --
> Denis
>
>
>
> On 2/29/2016 10:52 AM, smilehong(洪利平) wrote:
>
> Hi, all
>
> when I use the “select * from XX where XX” in ignite, how can I only get
> the local data ? because it obtain data on all nodes default. And I have
> configure the cache modes is partitioned mode.
>
> Thank you very much!
>
>
>
>
>
答复: How can I only get the local data(Internet mail)
Posted by "smilehong (洪利平)" <sm...@tencent.com>.
thank you, and you means that use Query.setLocal(true) can achieve this goal ?
发件人: Dmitriy Setrakyan [mailto:dsetrakyan@apache.org]
发送时间: 2016年3月1日 5:30
收件人: user
主题: Re: How can I only get the local data(Internet mail)
I think the answer is to use Query.setLocal(true) flag which will return correct results on the stable topology. The issue with changing topology is being addressed right now and should become part of the next release.
D.
On Mon, Feb 29, 2016 at 3:11 AM, Denis Magda <dm...@gridgain.com>> wrote:
Hi,
Presently there is no a reliable way to execute a SQL query over local collocated data.
Even if you set Query.setLocal to "true" there is a chance that you will get incomplete result set if re-partitioning happened at some point of the query execution.
However, it's planned to support the feature that will execute a query on a specific machine if it's know that all the data is located there.
Igniters, have we already created a ticket for this feature?
--
Denis
On 2/29/2016 10:52 AM, smilehong(洪利平) wrote:
Hi, all
when I use the “select * from XX where XX” in ignite, how can I only get the local data ? because it obtain data on all nodes default. And I have configure the cache modes is partitioned mode.
Thank you very much!
Re: How can I only get the local data
Posted by Dmitriy Setrakyan <ds...@apache.org>.
I think the answer is to use Query.setLocal(true) flag which will return
correct results on the stable topology. The issue with changing topology is
being addressed right now and should become part of the next release.
D.
On Mon, Feb 29, 2016 at 3:11 AM, Denis Magda <dm...@gridgain.com> wrote:
> Hi,
>
> Presently there is no a reliable way to execute a SQL query over local
> collocated data.
> Even if you set Query.setLocal to "true" there is a chance that you will
> get incomplete result set if re-partitioning happened at some point of the
> query execution.
>
> However, it's planned to support the feature that will execute a query on
> a specific machine if it's know that all the data is located there.
> Igniters, have we already created a ticket for this feature?
>
> --
> Denis
>
>
> On 2/29/2016 10:52 AM, smilehong(洪利平) wrote:
>
> Hi, all
>
> when I use the “select * from XX where XX” in ignite, how can I only get
> the local data ? because it obtain data on all nodes default. And I have
> configure the cache modes is partitioned mode.
>
> Thank you very much!
>
>
>
Re: How can I only get the local data
Posted by Denis Magda <dm...@gridgain.com>.
Hi,
Presently there is no a reliable way to execute a SQL query over local
collocated data.
Even if you set Query.setLocal to "true" there is a chance that you will
get incomplete result set if re-partitioning happened at some point of
the query execution.
However, it's planned to support the feature that will execute a query
on a specific machine if it's know that all the data is located there.
Igniters, have we already created a ticket for this feature?
--
Denis
On 2/29/2016 10:52 AM, smilehong(洪利平) wrote:
>
> Hi, all
>
> when I use the “select * from XX where XX” in ignite, how can I only
> get the local data ? because it obtain data on all nodes default. And
> I have configure the cache modes is partitioned mode.
>
> Thank you very much!
>