16.20 - Sessionize Input - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - NewSQL Engine Analytic Functions

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
July 2019
Content Type
Programming Reference
Publication ID
B035-1206-162K
Language
English (United States)

Input Table Schema

Column Data Type Description
time_column TIME, TIMESTAMP, INTEGER, BIGINT, or SMALLINT 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;