Hello!

I think this suggests data model adjustment.

Regards,
-- 
Ilya Kasnacheev


вт, 15 сент. 2020 г. в 17:46, Evgenii Zhuravlev <e.zhuravlev...@gmail.com>:

> Ilya,
>
> This won't help, since the problem here is that CQ doesn't return all
> needed keys.
>
> Evgenii
>
> вт, 15 сент. 2020 г. в 02:28, Ilya Kasnacheev <ilya.kasnach...@gmail.com>:
>
>> Hello!
>>
>> Maybe keys may be queued from the CQ to be revisited later with
>> transaction per key approach.
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> пн, 14 сент. 2020 г. в 21:15, Evgenii Zhuravlev <e.zhuravlev...@gmail.com
>> >:
>>
>>> No, I don't see other ways to do this transactionally, as CQ itself is
>>> not transactional.
>>>
>>> Evgenii
>>>
>>> чт, 10 сент. 2020 г. в 00:52, ssansoy <s.san...@cmcmarkets.com>:
>>>
>>>> unfortunately the 's' on B here can't be derived from a number 0..n -
>>>> e.g. it
>>>> isn't a numeric id.
>>>>
>>>> E.g. in practice lets say:
>>>>
>>>> A is a "Location"
>>>> it has properties: "city", "street" etc
>>>>
>>>> B is a "Person" with key:
>>>> p = city
>>>> q = street
>>>> r = social security number
>>>>
>>>> E.g. an A and associated B's are updated in a transaction, we want our
>>>> client app to see the updated A and B's where the Person lives at that
>>>> that
>>>> Location.
>>>>
>>>> E.g. A is updated and our continuous query on A picks up:
>>>> city = London
>>>> street = Downing Street
>>>>
>>>> We would like to say:
>>>> Select * from B where city="London" and street="Downing Street"
>>>>
>>>> Is there any way at all in Ignite to do this transactionally, so if an
>>>> A and
>>>> associated B's are updated in one transaction (e.g. a street is renamed
>>>> from
>>>> "Downing Street" to "Regent Street"), then our client app can see them
>>>> consistently?
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>>>
>>>

Reply via email to