Mailing-List: contact issues-help@flink.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@flink.apache.org
Date: Tue, 7 Mar 2017 15:18:38 +0000 (UTC)
From: "sunjincheng (JIRA)" <jira@apache.org>
To: issues@flink.apache.org
Message-ID: <JIRA.13043166.1487138907000.2245.1488899918158@Atlassian.JIRA>
In-Reply-To: <JIRA.13043166.1487138907000@Atlassian.JIRA>
References: <JIRA.13043166.1487138907000@Atlassian.JIRA> <JIRA.13043166.1487138907294@jira-lw-us.apache.org>
Subject: [jira] [Commented] (FLINK-5804) Add [non-partitioned] processing
 time OVER RANGE BETWEEN UNBOUNDED PRECEDING aggregation to SQL
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
archived-at: Tue, 07 Mar 2017 15:18:45 -0000


    [ https://issues.apache.org/jira/browse/FLINK-5804?page=3Dcom.atlassian=
.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D1589=
9582#comment-15899582 ]=20

sunjincheng commented on FLINK-5804:
------------------------------------

[~fhueske] Yes, I just thought wrong, ProcessFunction enough.=20
Tomorrow I will open this PR=EF=BC=81
Best=EF=BC=8C
SunJincheng

> Add [non-partitioned] processing time OVER RANGE BETWEEN UNBOUNDED PRECED=
ING aggregation to SQL
> -------------------------------------------------------------------------=
----------------------
>
>                 Key: FLINK-5804
>                 URL: https://issues.apache.org/jira/browse/FLINK-5804
>             Project: Flink
>          Issue Type: Sub-task
>          Components: Table API & SQL
>            Reporter: sunjincheng
>            Assignee: sunjincheng
>
> The goal of this issue is to add support for OVER RANGE aggregations on p=
rocessing time streams to the SQL interface.
> Queries similar to the following should be supported:
> {code}
> SELECT=20
>   a,=20
>   SUM(b) OVER (ORDER BY procTime() RANGE BETWEEN UNBOUNDED PRECEDING AND =
CURRENT ROW) AS sumB,
>   MIN(b) OVER (ORDER BY procTime() RANGE BETWEEN UNBOUNDED PRECEDING AND =
CURRENT ROW) AS minB
> FROM myStream
> {code}
> The following restrictions should initially apply:
> - All OVER clauses in the same SELECT clause must be exactly the same.
> - Since no PARTITION BY clause is specified, the execution will be single=
 threaded.
> - The ORDER BY clause may only have procTime() as parameter. procTime() i=
s a parameterless scalar function that just indicates processing time mode.
> - bounded PRECEDING is not supported (see FLINK-5654)
> - FOLLOWING is not supported.
> The restrictions will be resolved in follow up issues. If we find that so=
me of the restrictions are trivial to address, we can add the functionality=
 in this issue as well.
> This issue includes:
> - Design of the DataStream operator to compute OVER ROW aggregates
> - Translation from Calcite's RelNode representation (LogicalProject with =
RexOver expression).


--
This message was sent by Atlassian JIRA
(v6.3.15#6346)