Sessionize Function Example | Teradata Vantage - Sessionize Example - Teradata® Database

Input

Every complete example in this document is available in a zip file that you can download. The zip file includes a SQL script file that creates the input tables for the examples. If you are reading this document on https://docs.teradata.com/, you can download the zip file from the attachment in the left sidebar.

SQL Call

SELECT * FROM Sessionize (
  ON sessionize_table PARTITION BY partition_id ORDER BY clicktime
  USING
  TimeColumn ('clicktime')
  TimeOut (60)
  ClickLag (0.2)
) ORDER BY partition_id, clicktime;

Output