Ordered initial query for continuous query in Ignite .Net

[Barney Pippin <ja...@uk.bnpparibas.com>]

Hi,

I'm just upgrading to Ignite 2.8 and see that SqlQuery has been deprecated
directing us to SqlFieldsQuery, ScanQuery or Text. Previously I had a
continuous query running that took an SqlQuery which had "order by xyz" as
part of the initial query so I could get ordered results back upfront. 

Can anyone advise how I can achieve the same in 2.8 given that
SqlFieldsQuery isn't derived from QueryBase and I've yet to spot an ordering
option for text or scan queries.

Hopefully I've just missed something in the docs!

Many thanks,

James 



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ordered initial query for continuous query in Ignite .Net

[Pavel Tupitsyn <pt...@apache.org>]

Hi James,

This is a very good catch!
I've filed a ticket, we'll fix it in the next version:
https://issues.apache.org/jira/browse/IGNITE-13031

For now please continue using SqlQuery, it is functional as before.

Thank you,
Pavel

On Tue, May 19, 2020 at 10:42 AM Barney Pippin <
james.prince@uk.bnpparibas.com> wrote:

> Hi,
>
> I'm just upgrading to Ignite 2.8 and see that SqlQuery has been deprecated
> directing us to SqlFieldsQuery, ScanQuery or Text. Previously I had a
> continuous query running that took an SqlQuery which had "order by xyz" as
> part of the initial query so I could get ordered results back upfront.
>
> Can anyone advise how I can achieve the same in 2.8 given that
> SqlFieldsQuery isn't derived from QueryBase and I've yet to spot an
> ordering
> option for text or scan queries.
>
> Hopefully I've just missed something in the docs!
>
> Many thanks,
>
> James
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>