[CALCITE-3780] SESSION Table-valued Function

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.23.0
• Assignee: Rui Wang
• Reporter: Rui Wang
• Created: 07/Feb/20 21:11
• Updated: 14/Oct/20 10:14
• Resolved: 09/May/20 12:27

Description

We can create SESSION table-valued function to replace GROUP BY SESSION for inactive gap session functionality:

SELECT *
FROM TABLE SESSION (
  data => TABLE Bid ,
  timecol => DESCRIPTOR ( bidtime ) ,
  keycol => DESCRIPTOR(key),
  inactive_gap => INTERVAL '10' MINUTES )

 

 

Issue Links

• is related to: CALCITE-4337 Support PARTITION BY clause in table function call
• links to: Github Pull Request #1761