Re: Data lose in query

Web Console currently does not allow to specify affinity keys on configuration screen, there is a ticket for this improvement: https://issues.apache.org/jira/browse/IGNITE-4709 For now the only option is to manually set the required annotations in generated classes. -Val -- Sent from:

Re: Data lose in query

Exactly, I have faced the same problem and posted this question to the forum, not yet got any response. Thanks On 12-Dec-2017 1:48 PM, "Ahmad Al-Masry" wrote: > Hi; > I added @AffinityKeyMapped to the fields in the model generated by web > console. > But I also noticed that

Re: Data lose in query

It depends from your data model and can't be enabled via one property. Please, look at the following documentation pages: https://apacheignite.readme.io/docs/affinity-collocation https://apacheignite-sql.readme.io/docs/distributed-joins#collocated-joins On Mon, Dec 11, 2017 at 4:02 PM, Ahmad

Re: Data lose in query

How can I enable this on the server configuration XML? BR > On Dec 11, 2017, at 2:31 PM, Nikolai Tikhonov wrote: > > Hi, > > Strongly recommend to care about collocation of your data (as above suggested > by Vlad) instead of enable DistributedJoins flag. The performance

Re: Data lose in query

Hi, Strongly recommend to care about collocation of your data (as above suggested by Vlad) instead of enable DistributedJoins flag. The performance of this type of joins is worse then the performance of the affinity collocation based joins due to the fact that there will be much more network

Re: Data lose in query

Hi; When I enabled the distributed JOIN, get the following Exception: java.sql.SQLException: javax.cache.CacheException: Failed to prepare distributed join query: join condition does not use index [joinedCache=PositionTypeCache Should I remove the indexes before doing distributed joins? BR >

Re: Data lose in query

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