17.05 - Sessionize Input - 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

Input Table Schema

Column Data Type Description
time_column TIME, TIMESTAMP, INTEGER, BIGINT, SMALLINT, or DATE Click times (in milliseconds if data type is INTEGER, BIGINT, or SMALLINT).
partition_column Any [Column appears once for each specified partition_column.] Column by which input data is partitioned. Input data must be partitioned such that each partition contains all rows of an entity.
order_column Any [Column appears once for each specified order_column.] Column by which input data is ordered.

No input table column can have the name 'sessionid' or 'clicklag', because these are output table column names.

Tip: To create a single timestamp column from separate date and time columns:
SELECT (datecolumn || ' ' || timecolumn)::timestamp AS mytimestamp FROM table;