Hi, When you use JOIN, you should to enable DistributedJoins flag[1], or tack care about collocated of each joined entry[2].
[1]: org.apache.ignite.cache.query.SqlFieldsQuery#setDistributedJoins [2]: https://apacheignite.readme.io/docs On Mon, Dec 11, 2017 at 11:36 AM, Ahmad Al-Masry <[email protected]> wrote: > Dears; > The when I execute the attached query on Mysql data source or on a single > node ignite, it returns about 25k records. > When multiple node, it gives me about 3500 records. > The caches are atomic and partitioned. > Any suggestions. > BR > > -- > > > > This email, and the content it contains, are intended only for the persons > or entities to which it is addressed. It may contain sensitive, > confidential and/or privileged material. Any review, retransmission, > dissemination or other use of, or taking of any action in reliance upon, > this information by persons or entities other than the intended > recipient(s) is prohibited. If you received this email in error, please > immediately contact security[at]harri[dot]com and delete it from any device > or system on which it may be stored. > -- Vladislav Pyatkov
