RE: OVER() clause in ignite

2018-10-24 Thread Sriveena Mattaparthi
Thanks Andrey… Regards, Sriveena From: Andrey Mashenkov [mailto:andrey.mashen...@gmail.com] Sent: Wednesday, October 24, 2018 1:07 PM To: user@ignite.apache.org; Sriveena Mattaparthi Subject: Re: OVER() clause in ignite Hi, Ignite have no support window functions due to lack of underlying H2

Re: OVER() clause in ignite

2018-10-24 Thread wt
i noticed H2 roadmap for the current version has windowing functions. http://www.h2database.com/html/roadmap.html i guess this will mean ignite will have it available in the near future? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: OVER() clause in ignite

2018-10-24 Thread Andrey Mashenkov
> *Sent:* Wednesday, October 24, 2018 11:47 AM > *To:* user@ignite.apache.org > *Subject:* Re: OVER() clause in ignite > > > > Hi! > > As far as I know H2 does not support OVER. > > Mikael > > Den 2018-10-24 kl. 07:28, skrev Sriveena Mattaparthi: > > Do we s

RE: OVER() clause in ignite

2018-10-24 Thread Sriveena Mattaparthi
Thanks Mikael Regards, Sriveena From: Mikael [mailto:mikael-arons...@telia.com] Sent: Wednesday, October 24, 2018 12:36 PM To: user@ignite.apache.org Subject: Re: OVER() clause in ignite Hi! I am not sure, but you might find something useful here: https://stackoverflow.com/questions/6249449

Re: OVER() clause in ignite

2018-10-24 Thread Mikael
other alternative to achieve this? Regards, Sriveena *From:*Mikael [mailto:mikael-arons...@telia.com] *Sent:* Wednesday, October 24, 2018 11:47 AM *To:* user@ignite.apache.org *Subject:* Re: OVER() clause in ignite Hi! As far as I know H2 does not support OVER. Mikael Den 2018-10-24 kl. 07

RE: OVER() clause in ignite

2018-10-23 Thread Sriveena Mattaparthi
Thanks Mikael..Could you please suggest any other alternative to achieve this? Regards, Sriveena From: Mikael [mailto:mikael-arons...@telia.com] Sent: Wednesday, October 24, 2018 11:47 AM To: user@ignite.apache.org Subject: Re: OVER() clause in ignite Hi! As far as I know H2 does not support

Re: OVER() clause in ignite

2018-10-23 Thread Mikael
Hi! As far as I know H2 does not support OVER. Mikael Den 2018-10-24 kl. 07:28, skrev Sriveena Mattaparthi: Do we support over() clause in SQL in ignite like select count(*) over() totalrecords  from EMPLOYEE; please confirm. Thanks & Regards, Sriveena “Confidentiality Notice: The conten

RE: Over clause in ignite

2018-10-23 Thread Sriveena Mattaparthi
I am not the intended recipient of this email From: Sriveena Mattaparthi [mailto:sriveena.mattapar...@ekaplus.com] Sent: Wednesday, October 24, 2018 11:14 AM To: user@ignite.apache.org Subject: Over clause in ignite Do we support over() clause in ignite SQL queries like select count(*) over

Over clause in ignite

2018-10-23 Thread Sriveena Mattaparthi
Do we support over() clause in ignite SQL queries like select count(*) over() totalrecords from EMPLOYEE; please confirm. Thanks & Regards, Sriveena "Confidentiality Notice: The contents of this email message and any attachments are intended solely for the addressee(s) and ma

RE: OVER() clause in ignite

2018-10-23 Thread Sriveena Mattaparthi
Do we support over() clause in SQL in ignite like select count(*) over() totalrecords from EMPLOYEE; please confirm. Thanks & Regards, Sriveena "Confidentiality Notice: The contents of this email message and any attachments are intended solely for the addressee(s) and may contain confidential

OVER() clause in ignite

2018-10-23 Thread Sriveena Mattaparthi
Do we support over() clause in SQL in ignite like select count(*) over() totalrecords from EMPLOYEE; please confirm. Thanks & Regards, Sriveena "Confidentiality Notice: The contents of this email message and any attachments are intended solely for the addressee(s) and may contain confidential