16.10 - Usage Notes - Teradata Database

Teradata Analytic Functions

prodname
Teradata Database
vrm_release
15.10
16.10
created_date
November 2017
category
Programming Reference
featnum
B035-1206-151K

ON Clause Usage Notes

  • SESSIONIZE can have only one ON clause.
  • The following combinations are allowed in the ON clause:
    • PARTITION BY ORDER BY
    • PARTITION BY
  • PARTITION BY ANY, DIMENSION, HASH BY and LOCAL ORDER BY are not allowed in the ON Clause.
  • You can associate an optional alias with the ON Clause input table by using the AS name clause.

SESSIONIZE Function Output

The output of the SESSIONIZE function includes all columns from the input and an additional column named sessionid that contains the assigned session identifiers. If CLICKLAG is also specified in the call, then an additional column named CLICKLAG is generated. The data type of the CLICKLAG column is CHAR and can contain a t or f value, which corresponds to TRUE or FALSE. Since the output columns of SESSIONIZE are called sessionid and CLICKLAG, the input columns cannot use these names.