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