1.0 - 8.00 - Burst Input - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)
Table Description
input_table Contains time intervals to burst.
time_table [Optional] Contains start and end times of burst intervals. This table lets you use different time intervals and partitions the data accordingly.

If you omit this table, you must specify either the TimeInterval or NumPoints argument.

input_table Schema

Each row contains a time interval to burst.

Column Data Type Description
start_time_column INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, NUMERIC, DATE, TIME, TIME(n), TIMESTAMP Interval start time.
end_time_column INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION,NUMERIC, DATE, TIME, TIME(n), TIMESTAMP, TIMESTAMP(n) Interval end time.
target_column INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, NUMERIC, CHARACTER, CHARACTER(n), VARCHAR Column to copy to output table.

If SplitCriteria is not 'nosplit', ValueDataType must be DOUBLE PRECISION.

accumulate_column Any [Optional] Column to copy to output table.

Typically, one accumulate_column is a row identifier, such as 'id'.

time_table Schema

Each row contains the start and end times of a burst interval.

Column Data Type Description
id Any Row identifier.

If input_table row i is to be burst into n intervals, time_table has n rows with id value i.

burst_start_time INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, NUMERIC, DATE, TIME, TIME(n), TIMESTAMP, TIMESTAMP(n) Interval start time.
burst_end_time INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, NUMERIC, DATE, TIME, TIME(n), TIMESTAMP Interval end time.