[ https://issues.apache.org/jira/browse/CALCITE-3780?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17166179#comment-17166179 ]
duli commented on CALCITE-3780: ------------------------------- If we use window table function with group by clause, and we merge window by the field in group by clause, so the 'keycol' is not required(the same features like session group window in Flink). Another use case continue to use your example: we want to analysis the user sessionization across the entire server, we also don't need it. > SESSION Table-valued Function > ----------------------------- > > Key: CALCITE-3780 > URL: https://issues.apache.org/jira/browse/CALCITE-3780 > Project: Calcite > Issue Type: Sub-task > Reporter: Rui Wang > Assignee: Rui Wang > Priority: Major > Fix For: 1.23.0 > > > We can create SESSION table-valued function to replace GROUP BY SESSION for > inactive gap session functionality: > {code:sql} > SELECT * > FROM TABLE SESSION ( > data => TABLE Bid , > timecol => DESCRIPTOR ( bidtime ) , > keycol => DESCRIPTOR(key), > inactive_gap => INTERVAL '10' MINUTES ) > {code} > > -- This message was sent by Atlassian Jira (v8.3.4#803005)