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. 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<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fissues.apache.org%2Fjira%2Fbrowse%2FIGNITE-2177&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Ce9bb7fe8544b491a98e608d639838483%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636759634391503123&sdata=DTw5KI79Sqm11genZCHZOT5AHKgzqRpRV8OblOC5keg%3D&reserved=0> [2] https://issues.apache.org/jira/browse/IGNITE-6918<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fissues.apache.org%2Fjira%2Fbrowse%2FIGNITE-6918&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7Ce9bb7fe8544b491a98e608d639838483%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636759634391503123&sdata=8yZh%2BfUdBl3QDCCHzZcQ6AVt5vxEXBQCqh8tULLY96c%3D&reserved=0> On Wed, Oct 24, 2018 at 9:55 AM Sriveena Mattaparthi <sriveena.mattapar...@ekaplus.com<mailto: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<mailto:mikael-arons...@telia.com>] Sent: Wednesday, October 24, 2018 11:47 AM To: user@ignite.apache.org<mailto: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 “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.”