Hi, Ignite have no support window functions due to lack of underlying H2. OVER is a part of SQL ANSI'03 standart, but Ignite claims to be ANSI'99 complaint.
The only workaround is to rewrite query with using joins or calculate result manually. User aggregate functions also are not supported and we have no plans for this, see IGNITE-2177 [1]. There is ticket for Window-functions support IGNITE-6918 [2], but it is not planned to any future version for now. [1] https://issues.apache.org/jira/browse/IGNITE-2177 [2] https://issues.apache.org/jira/browse/IGNITE-6918 On Wed, Oct 24, 2018 at 9:55 AM Sriveena Mattaparthi < sriveena.mattapar...@ekaplus.com> wrote: > 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 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 contents of this email message and any > attachments are intended solely for the addressee(s) and may contain > confidential and/or privileged information and may be legally protected > from disclosure. If you are not the intended recipient of this message or > their agent, or if this message has been addressed to you in error, please > immediately alert the sender by reply email and then delete this message > and any attachments. If you are not the intended recipient, you are hereby > notified that any use, dissemination, copying, or storage of this message > or its attachments is strictly prohibited.” > > > “Confidentiality Notice: The contents of this email message and any > attachments are intended solely for the addressee(s) and may contain > confidential and/or privileged information and may be legally protected > from disclosure. If you are not the intended recipient of this message or > their agent, or if this message has been addressed to you in error, please > immediately alert the sender by reply email and then delete this message > and any attachments. If you are not the intended recipient, you are hereby > notified that any use, dissemination, copying, or storage of this message > or its attachments is strictly prohibited.” > -- Best regards, Andrey V. Mashenkov
