[jira] [Comment Edited] (CALCITE-3271) TVF windowing and EMIT syntax support in Calcite

["Rui Wang (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-3271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16913762#comment-16913762 ] 

Rui Wang edited comment on CALCITE-3271 at 8/22/19 10:41 PM:
-------------------------------------------------------------

Thanks Julian for you feedback. I will add more to this JIRA to clarify what it's supposed to do and replace terms by some more standard way (e.g. terms from SQL standard). I actually will probably write down a small  summary of the paper and list gaps in Calcite to support the target syntax.


Thanks Jark for the pointer of blink's practice. It's great to know that it would be also useful to other projects. Currently I should formalize what should be done under this JIRA. It would be nice to get help on later technique discussion, implementation, etc.


was (Author: amaliujia):
Thanks Julian for you feedback. I will add more to this JIRA to clarify what it's supposed to do and replace terms by some more standard way (e.g. terms from SQL standard). I actually will probably write down a small  summary of the paper and list gaps in Calcite to support the target syntax.


Thanks Jark for the pointer of blink's practice. It's great to know that it would be also useful to other projects. Currently I should formalize what should be done under this JIRA. It would be nice to get help when on technique discussion, implementation, etc.

> TVF windowing and EMIT syntax support in Calcite
> ------------------------------------------------
>
>                 Key: CALCITE-3271
>                 URL: https://issues.apache.org/jira/browse/CALCITE-3271
>             Project: Calcite
>          Issue Type: Improvement
>          Components: core
>    Affects Versions: 1.20.0
>            Reporter: Danny Chan
>            Assignee: Rui Wang
>            Priority: Major
>
> Copied from the mailing list:
> Calcite has not implemented the syntax in that paper. I would support an effort to add it (unsurprising, since I am a co-author of that paper).
> EMIT STREAM is equivalent to the current SELECT STREAM syntax.
> There is no equivalent in current Calcite of the EMIT AFTER WATERMARK, or EMIT STREAM AFTER DELAY.
> HOP, TUMBLE and SESSION are supported in Calcite’s SQL parser, but following the paper would be replaced with a table function call. We could need to add HOP, TUMBLE and SESSION table functions. We would also need to make the system aware of how watermarks flow through these table functions (an area that the paper does not go into).
> Julian



--
This message was sent by Atlassian Jira
(v8.3.2#803003)