for reply again.
Bob
From: vkulichenko
Date: 2016-07-28 08:01
To: user@ignite.apache.org
Subject: Re: Re: SQL join query return different result under the same data
when having different ignite instance.
Hi Bob,
In this example Class table should also have schoolId field and schoolId
should
.70518.x6.nabble.com/SQL-join-query-return-different-result-under-the-same-data-when-having-different-ignite-instance-tp6433p6575.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
u can collocate by a single field only, otherwise
the data will end up on different nodes"
How to do for this scenario?
Bob
From: vkulichenko
Date: 2016-07-23 03:08
To: user@ignite.apache.org
Subject: Re: Re: SQL join query return different result under the same data
when having different ignit
switch one of the caches to REPLICATED mode.
Replicated caches don't need collocation, but they replicate all the data to
all nodes.
-Val
--
View this message in context:
http://apache-ignite-users.70518.x6.nabble.com/SQL-join-query-return-different-result-under-the-same-data-when-having
BETWEEN '2014-1-1' AND '2015-1-1'"
+ " AND Kc21.akc193 = Ka06.akc193";
Thanks everyone.
Bob
From: 胡永亮/Bob
Date: 2016-07-21 17:07
To: user@ignite.apache.org
Subject: Re: Re: SQL join query return different result under the same data
when having different ignite instance.
Hi
93 of object Kc21 also will join with the
column akc193 of object Ka06.
According to doc, I don't know how to config two affinitys.
Thanks.
Bob
From: Alexey Goncharuk
Date: 2016-07-21 16:00
To: user@ignite.apache.org
Subject: Re: SQL join query return different result under the sam
Hi,
Ignite 1.6 requires data to be properly collocated in order for joins to
work correctly. Namely, data being joined from tables Kc21 and Kc24 must be
collocated. See [1] for more details on affinity collocation and [2] for
more details on how SQL queries work. Also, take a look
at
hi, everyone:
I am using the ignite 1.6.
I have the sql query:
String querySql = "select count(*) FROm Kc21, \"Kc24Cache\".Kc24"
+ ", \"Ka06Cache\".Ka06, \"Kc60Cache\".Kc60 "
+ " WHERE kc21.akb020 = kc24.akb020"
+ " AND kc21.akc190 = kc24.akc190"
+ " AND kc24.akb020 = kc60.akb020"
+
