You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Sriveena Mattaparthi <Sr...@ekaplus.com> on 2018/10/24 05:28:50 UTC
OVER() clause in ignite
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."
RE: OVER() clause in ignite
Posted by Sriveena Mattaparthi <Sr...@ekaplus.com>.
Thanks Andrey…
Regards,
Sriveena
From: Andrey Mashenkov [mailto:andrey.mashenkov@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 <Sr...@ekaplus.com>> wrote:
Thanks Mikael..Could you please suggest any other alternative to achieve this?
Regards,
Sriveena
From: Mikael [mailto:mikael-aronsson@telia.com<ma...@telia.com>]
Sent: Wednesday, October 24, 2018 11:47 AM
To: user@ignite.apache.org<ma...@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.”
Re: OVER() clause in ignite
Posted by wt <wa...@gmail.com>.
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
Posted by Andrey Mashenkov <an...@gmail.com>.
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.Mattaparthi@ekaplus.com> wrote:
> Thanks Mikael..Could you please suggest any other alternative to achieve
> this?
>
>
>
> Regards,
>
> Sriveena
>
>
>
> *From:* Mikael [mailto:mikael-aronsson@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
RE: OVER() clause in ignite
Posted by Sriveena Mattaparthi <Sr...@ekaplus.com>.
Thanks Mikael
Regards,
Sriveena
From: Mikael [mailto:mikael-aronsson@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/is-h2-database-able-to-make-sql-query-of-the-over-clause-with-aggregate-function<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F6249449%2Fis-h2-database-able-to-make-sql-query-of-the-over-clause-with-aggregate-function&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C57a6bf08fed0464371f108d6397f2a8c%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636759615692736094&sdata=f9e4lkna49dOD5gJ2lpuppInptTA%2BD3T9WAeMne1OEE%3D&reserved=0>
Mikael
Den 2018-10-24 kl. 08:55, skrev Sriveena Mattaparthi:
Thanks Mikael..Could you please suggest any other alternative to achieve this?
Regards,
Sriveena
From: Mikael [mailto:mikael-aronsson@telia.com]
Sent: Wednesday, October 24, 2018 11:47 AM
To: user@ignite.apache.org<ma...@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."
"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."
Re: OVER() clause in ignite
Posted by Mikael <mi...@telia.com>.
Hi!
I am not sure, but you might find something useful here:
https://stackoverflow.com/questions/6249449/is-h2-database-able-to-make-sql-query-of-the-over-clause-with-aggregate-function
Mikael
Den 2018-10-24 kl. 08:55, skrev Sriveena Mattaparthi:
>
> Thanks Mikael..Could you please suggest any other alternative to
> achieve this?
>
> Regards,
>
> Sriveena
>
> *From:*Mikael [mailto:mikael-aronsson@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.”
RE: OVER() clause in ignite
Posted by Sriveena Mattaparthi <Sr...@ekaplus.com>.
Thanks Mikael..Could you please suggest any other alternative to achieve this?
Regards,
Sriveena
From: Mikael [mailto:mikael-aronsson@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."
Re: OVER() clause in ignite
Posted by Mikael <mi...@telia.com>.
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.”
RE: OVER() clause in ignite
Posted by Sriveena Mattaparthi <Sr...@ekaplus.com>.
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."