Sessionize Example - Teradata Vantage

Input

The input table, adweb_clickstream, contains web clickstream data recorded as a user navigates through a web site. Events—view, click, and so on—are recorded with a timestamp.

SQL Call

SELECT * FROM Sessionize@coprocessor (
  ON adweb_clickstream PARTITION BY userid ORDER BY clicktime
  USING
  TimeColumn ('clicktime')
  TimeOut (60)
  ClickLag (0.2)
) AS dt;

Output