ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sobolewski, Krzysztof" <Krzysztof.Sobolew...@gs.com>
Subject RE: Continuous queries and duplicates
Date Mon, 26 Nov 2018 09:43:53 GMT
Thanks. This is a little disappointing. ScanQuery would probably work, but it’s not as efficient
(can’t use indexes etc.). Are there any plans to enable isolation on SqlQuery?
-KS

From: Ilya Kasnacheev [mailto:ilya.kasnacheev@gmail.com]
Sent: 26 listopada 2018 08:01
To: user@ignite.apache.org
Subject: Re: Continuous queries and duplicates

Hello!

SQL queries have no isolation currently so it is not possible to avoid the problem that you
described. You could try switching to ScanQuery, see if it helps; or learning to deal with
duplicates.

Regards,
--
Ilya Kasnacheev


пт, 23 нояб. 2018 г. в 19:25, Sobolewski, Krzysztof <Krzysztof.Sobolewski@gs.com<mailto:Krzysztof.Sobolewski@gs.com>>:
Hi,

I'm wanting to use a ContinuousQuery and there is a slight issue with how it transitions from
the initial query to the notifications phase. It turns out that if there are additions to
the cache happening while the continuous query runs, an entry may be reported twice - once
by the initial query and once by the listener. This is confirmed by experiment, BTW :) The
initial query in this case is an SqlQuery.

So my question is: is this intentional? Or is it a bug? Is there something I can do to mitigate
this? Is this is an issue of isolation level?

Thanks a lot for any pointers :)
-KS

________________________________

Your Personal Data: We may collect and process information about you that may be subject to
data protection laws. For more information about how we use and disclose your personal data,
how we protect your information, our legal basis to use your information, your rights and
who you can contact, please refer to: www.gs.com/privacy-notices<http://www.gs.com/privacy-notices><http://www.gs.com/privacy-notices>

________________________________

Your Personal Data: We may collect and process information about you that may be subject to
data protection laws. For more information about how we use and disclose your personal data,
how we protect your information, our legal basis to use your information, your rights and
who you can contact, please refer to: www.gs.com/privacy-notices<http://www.gs.com/privacy-notices>
Mime
View raw message