Mailing-List: contact user-help@ignite.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ignite.apache.org
Date: Tue, 27 Oct 2015 08:29:00 -0700 (PDT)
From: iceguo <guoht@ffcs.cn>
To: user@ignite.apache.org
Message-ID: <1445959740137-1723.post@n6.nabble.com>
Subject: The result of cross-cache SQL joins is incomplete.
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

I had started 2 Ignite nodes, and put table "Person" and "Organization" to
these 2 Ignite nodes with all cache mode is =E2=80=9DPartitioned=E2=80=9C,

 then I did a cross-cache SQL joins as following:
"select Person.firstName from Person, \"OrganizationCache\".Organization
where Person.orgid =3D Organization.id and Organization.name =3D ?".

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.co=
m/The-result-of-cross-cache-SQL-joins-is-incomplete-tp1723.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.