ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ilya Kasnacheev <ilya.kasnach...@gmail.com>
Subject Re: ***UNCHECKED*** Executing SQL on cache using affinnity key
Date Wed, 25 Jul 2018 10:15:36 GMT
Hello!

I hope that Ignite statement planner will make use of affinity key if you
provide it in the request. I.e. it will not be broadcast if you provide
affinity key.

Regards,

-- 
Ilya Kasnacheev

2018-07-25 10:58 GMT+03:00 Stanislav Lukyanov <stanlukyanov@gmail.com>:

> What do you mean by “execute select query on cache using affinity key”
>
> and what is the problem you’re trying to solve?
>
>
>
> Stan
>
>
>
> *From: *Prasad Bhalerao <prasadbhalerao1983@gmail.com>
> *Sent: *25 июля 2018 г. 10:03
> *To: *user@ignite.apache.org
> *Subject: ****UNCHECKED*** Executing SQL on cache using affinnity key
>
>
>
> Hi,
>
>
>
> Is there any way to execute select query on cache using affinity key?
>
>
>
> As per this link: https://apacheignite.readme.io/docs/collocate-
> compute-and-data#section-affinity-call-and-run-methods
>
>
>
> It can be done as follows:
>
>
>
> compute.affinityCall(*CACHE_NAME*, *affinityKey*, () -> {
>
>   SqlFieldsQuery sqlFieldsQuery = *new *SqlFieldsQuery(SELECT_STATEMENT).setArgs(args);
>   sqlFieldsQuery.setDistributedJoins(*false*);
>   sqlFieldsQuery.setLocal(*true*);
>   sqlFieldsQuery.setCollocated(*true*);
>   *return *cache().query(sqlFieldsQuery);
> });
>
> Is there any other way to do it?
>
>
>
> Thanks,
>
> Prasad
>
>
>

Mime
View raw message