[ 
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)

Reply via email to