ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nikolai Tikhonov <ntikho...@apache.org>
Subject Re: Data lose in query
Date Mon, 11 Dec 2017 13:12:54 GMT
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 Al-Masry <masry@harri.com> wrote:

> How can I enable this on the server configuration XML?
> BR
>
>
> On Dec 11, 2017, at 2:31 PM, Nikolai Tikhonov <ntikhonov@apache.org>
> wrote:
>
> 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 round-trips and data movement between the nodes to fulfill a query
> [1].
>
> 1. https://apacheignite-sql.readme.io/docs/distributed-
> joins#non-collocated-joins
>
>
> On Mon, Dec 11, 2017 at 3:03 PM, Ahmad Al-Masry <masry@harri.com> wrote:
>
>> 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
>>
>>
>> On Dec 11, 2017, at 10:43 AM, Vladislav Pyatkov <vldpyatkov@gmail.com>
>> wrote:
>>
>> 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 <masry@harri.com> 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
>>
>>
>>
>>
>> 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.
>>
>
>
>
>
> 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.
>

Mime
View raw message