[
https://issues.apache.org/jira/browse/FLINK-4678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Fabian Hueske updated FLINK-4678:
---------------------------------
Summary: Add SessionRow row-windows to Table API (was: Add SessionRow
row-windows for streaming tables (FLIP-11))
> Add SessionRow row-windows to Table API
> ---------------------------------------
>
> Key: FLINK-4678
> URL: https://issues.apache.org/jira/browse/FLINK-4678
> Project: Flink
> Issue Type: Sub-task
> Components: Table API & SQL
> Affects Versions: 1.2.0
> Reporter: Fabian Hueske
> Assignee: Timo Walther
>
> Add SessionRow row-windows for streaming tables as described in
> [FLIP-11|https://cwiki.apache.org/confluence/display/FLINK/FLIP-11%3A+Table+API+Stream+Aggregations].
>
> SessionRow row windows are a syntactic shortcut for a special type of SQL
> OVER windows, i.e., windows of the from (note this is not valid SQL):
> {code}
> SELECT STREAM rowtime,
> productId,
> units,
> SUM(units) OVER (PARTITION BY sessionId(rowtime, INTERVAL '5' MINUTES) ))
> AS unitsSinceTopOfHour
> FROM Orders;
> {code}
> i.e., OVER windows which are partitioned by a special function sessionId over
> the time attribute (the second argument defines the gap between sessions).
> This issue is about extending the Table API with the SessionRow shortcut. It
> should reuse a lot of the OVER window translation and runtime code
> implemented by FLINK-5653, FLINK-5654, FLINK-5655, FLINK-5656, FLINK-5657,
> and FLINK-5658 but will likely require to add a special type of window
> boundary inside of Calcite to hold the session semantics.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
