1.1 - 8.10 - Interpolator Output - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Published
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

Output Table Schema

Column Data Type Description
time_column INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, NUMERIC, DATE, TIME, TIME(n), TIMESTAMP, TIMESTAMP(n) Time point in time series. Corresponds to time_column in InputTable.
target_column INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, NUMERIC, CHARACTER, CHARACTER(n), or VARCHAR

For data types CHARACTER, CHARACTER(n), and VARCHAR, you cannot use AggregationType. You must use InterpolationType, and interpolation_type must be 'constant'.

[Column appears one or more times.] Time point value. Corresponds to a target_column in InputTable.
accumulate_column Same as in InputTable [Column appears once for each specified accumulate_column.] Column copied from input table.

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

These columns appear in same order in the input and output tables.