[jira] [Comment Edited] (FLINK-5710) Add ProcTime() function to indicate StreamSQL

["Haohui Mai (JIRA)" <ji...@apache.org>]

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

Haohui Mai edited comment on FLINK-5710 at 2/7/17 1:47 PM:
-----------------------------------------------------------

Can you please elaborate a little bit more, particularly how to generate a user friendly message? For example:

{code}
SELECT FLOOR(procTime() TO HOURS) as ts, COUNT(*) FROM foo GROUP BY FLOOR(procTime() TO HOURS)
{code}

The query translation can recognize certain usages of {{procTime()}} (e.g., {{FLOOR}}) but other usages might result in mysterious error messages (i.e., cannot do codegen for the {{procTime()}} function). Any ideas?


was (Author: wheat9):
Can you please elaborate a little bit more, particularly how the code generator will work? For example:

{code}
SELECT COUNT(*) FROM foo GROUP BY FLOOR(procTime() TO HOURS)
{code}

Essentially {{procTime()}} becomes an expression and the code generator needs to generate some code in order to execute the query. I have tried similar things on {{rowTime()}} and I found that it is nontrivial to refer to the datastream. Thoughts?

> Add ProcTime() function to indicate StreamSQL
> ---------------------------------------------
>
>                 Key: FLINK-5710
>                 URL: https://issues.apache.org/jira/browse/FLINK-5710
>             Project: Flink
>          Issue Type: New Feature
>          Components: DataStream API
>            Reporter: Stefano Bortoli
>            Assignee: Stefano Bortoli
>            Priority: Minor
>
> procTime() is a parameterless scalar function that just indicates processing time mode



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