From user-return-22624-archive-asf-public=cust-asf.ponee.io@ignite.apache.org Wed Oct 24 09:06:05 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id BCEE4180638 for ; Wed, 24 Oct 2018 09:06:04 +0200 (CEST) Received: (qmail 39468 invoked by uid 500); 24 Oct 2018 07:06:03 -0000 Mailing-List: contact user-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ignite.apache.org Delivered-To: mailing list user@ignite.apache.org Received: (qmail 39457 invoked by uid 99); 24 Oct 2018 07:06:03 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Oct 2018 07:06:03 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 3FCED1A23C1 for ; Wed, 24 Oct 2018 07:06:03 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.309 X-Spam-Level: * X-Spam-Status: No, score=1.309 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, SPF_PASS=-0.001, T_KAM_HTML_FONT_INVALID=0.01] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id dAjPOu0I8J4K for ; Wed, 24 Oct 2018 07:06:02 +0000 (UTC) Received: from v-smtpout1.han.skanova.net (v-smtpout1.han.skanova.net [81.236.60.154]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 94C525F433 for ; Wed, 24 Oct 2018 07:06:01 +0000 (UTC) Received: from [192.168.1.92] ([81.232.80.243]) by cmsmtp with ESMTPA id FDEugwMK3ONS2FDEugTQ3D; Wed, 24 Oct 2018 09:06:00 +0200 Subject: Re: OVER() clause in ignite To: user@ignite.apache.org References: <70804ecf-5816-ee5e-95d1-4a60b8042714@telia.com> From: Mikael Message-ID: Date: Wed, 24 Oct 2018 09:06:02 +0200 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------85DEF3F2C90A09306F9FB708" Content-Language: en-US X-CMAE-Envelope: MS4wfGNNsLIauQXeXD0wfhkn0AyNvDf6RG36PoO1pdwRlteTqNV6VGt7hCN9M5yyYvtXZppRfENtFp59upwimBP1M3wEdtmBTjJO1+Jx4vud+V6HlGpORKKb mDd9kKNm/ftgmNDXcV8T7OKXZmFW3tTK9y99k5D79w3nakAgDEWgNHPYuotg8zFya+6KfnrCaamXjA== This is a multi-part message in MIME format. --------------85DEF3F2C90A09306F9FB708 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit 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.� --------------85DEF3F2C90A09306F9FB708 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: 8bit

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.�

--------------85DEF3F2C90A09306F9FB708--