Burst Input - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.00
1.0
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢
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.