Hi Evgenii,
Are you saying that if the affinityKey column is present in WHERE clause of
SQL statement, the SQL engine will detect a node where this key is placed
and execute this query only on one node.
I just want to make sure that SQL gets executed only on node where the
affinity key is placed.
Yes, that’s exactly how Ignite SQL works by default.
Stan
From: Prasad Bhalerao
Sent: 25 июля 2018 г. 15:35
To: user@ignite.apache.org
Subject: Re: ***UNCHECKED*** Executing SQL on cache using affinnity key
I want to get the data from multiple caches using SELECT query from client
node
Are you saying that if the affinityKey is present in WHERE clause of SQL
statement, the SQL engine will detect a node where this key is placed and
execute this query only on one node.
I just want to make sure that SQL gets executed only on node where the
affinity key is placed.
I was trying to
I want to get the data from multiple caches using SELECT query from client
node. The affinity key for all the caches is same.
Since I know that the data in all caches is collocated, I just want make
sure that sql gets executed only on one of the node(which is primary or
secondary for that data)
Hi Evgenii,
Are you saying that if the affinityKey column is present in WHERE clause of
SQL statement, the SQL engine will detect a node where this key is placed
and execute this query only on one node.
I just want to make sure that SQL gets executed only on node where the
affinity key is
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 :
> What do you mean by “execute select query on
When you run SQL query with filtering on Affinity key field, the SQL engine
will detect a node where this key is placed and execute this query only on
one node.
What are you trying to achieve?
Evgenii
2018-07-25 10:00 GMT+03:00 Prasad Bhalerao :
> Hi,
>
> Is there any way to execute select
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
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