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.
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;