17.05 - Sessionize Syntax Elements - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Analytic Functions

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1206-170K
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'