7.00.02 - Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Aster Analytics
Release Number
September 2017
Content Type
Programming Reference
User Guide
Publication ID
English (United States)
Last Update

The input table must have a timestamp column and columns by which to partition and order the data. Input data must be partitioned such that each partition contains all rows of an entity. No input column can have the name 'sessionid' or 'clicklag', because these are output column names.

Sessionize Input Table Schema
Column Name Data Type Description
timestamp_column TIME, TIMESTAMP, INTEGER, BIGINT, or SMALLINT Contains the click times. If the data type is INTEGER, BIGINT, or SMALLINT, the function treats the values as milliseconds.

To create a single timestamp column from separate date and time columns:

SELECT (datecolumn || ' ' || timecolumn)::timestamp AS mytimestamp FROM table;