ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergi Vladykin <sergi.vlady...@gmail.com>
Subject Re: The result of cross-cache SQL joins is incomplete.
Date Tue, 27 Oct 2015 16:22:31 GMT
You have to collocate Persons with their organizations, so that all
the Persons for any given Organization reside on the same node
with that Organization.

Read more here: https://apacheignite.readme.io/docs/affinity-collocation

Sergi


2015-10-27 18:29 GMT+03:00 iceguo <guoht@ffcs.cn>:

> I had started 2 Ignite nodes, and put table "Person" and "Organization" to
> these 2 Ignite nodes with all cache mode is ”Partitioned“,
>
>  then I did a cross-cache SQL joins as following:
> "select Person.firstName from Person, \"OrganizationCache\".Organization
> where Person.orgid = Organization.id and Organization.name = ?".
>
> then I found the result in incomplete, it losted almost half results.
>
> When I use cache mode is "replicated" or I use only one node, the result is
> complete.
>
> I want to know how to get the complete result between two PARTITIONED data
> sets with "Partitioned" cache mode.
>
>
>
> --
> View this message in context:
> http://apache-ignite-users.70518.x6.nabble.com/The-result-of-cross-cache-SQL-joins-is-incomplete-tp1723.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>

Mime
View raw message