Sessionize Syntax Elements - Teradata® Database

Database Analytic Functions

Product
Teradata® Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/wnd1589838592459.ditamap
dita:ditavalPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/ayr1485454803741.ditaval
dita:id
B035-1206
lifecycle
previous
Product Category
Teradata Vantage™
TimeColumn
Specify the name of the input column that contains the click times.
The time_column must also be an order_column.
TimeOut
Specify the number of seconds at which the session times out. If session_timeout seconds elapse after a click, the next click starts a new session. The data type of session_timeout is DOUBLE PRECISION.
ClickLag
[Optional] Specify the minimum number of seconds between clicks for the session user to be considered human. If clicks are more frequent, indicating that the user is a bot, the function ignores the session. The min_human_click_lag must be less than session_timout. The data type of min_human_click_lag is DOUBLE PRECISION.
Default behavior: The function ignores no session, regardless of click frequency.
EmitNull
[Optional] Specify whether to output rows that have NULL values in their session id and rapid fire columns, even if their time_column has a NULL value.
Default: 'false'