1.1 - 8.10 - Interpolator Input - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)
Table Description
InputTable Contains the time series whose missing values are to be calculated.
TimeIntervalTable [Optional] If you omit TimeIntervalTable, you must specify the TimeInterval syntax element.

If you specify AggregationType, the function ignores TimeInterval or TimeIntervalTable and calculates the aggregated value for each time point in the time series.

RowCounts [Optional] Use only with InterpolationType ('loess'(weights ({constant | tricube}), degree ({0 |1 |2}), span(m))), where m is between (λ+1)/n and 1.

InputTable Schema

Each row contains one time point in the series and one or more values.

Column Data Type Description
time_column INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, NUMERIC, DATE, TIME, TIME(n), TIMESTAMP, TIMESTAMP(n) Time point in time series.
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.
accumulate_column Any [Column appears once for each specified accumulate_column.] Column to copy to output table.

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

TimeIntervalTable Schema

If you specify AggregationType, the function ignores this table and calculates the aggregated value for each time point in the time series.

If using this table, the function calculates and outputs an interpolated value for each time point, replacing the original value of the time series at that point.

Column Data Type Description
time_column Data type of time_column in InputTable [Column appears one or more times.] Time point in time series whose missing values are to be calculated.

RowCounts Table Schema

This table has information about the shorter time intervals into which the original time series (in InputTable) has been split. Each row represents one shorter time interval.

Column Data Type Description
id INTEGER or VARCHAR if id is from SeriesSplitter output table; otherwise, any data type Identification number of shorter time interval.

If shorter time intervals are produced by SeriesSplitter (ML Engine) function, this value is from split_id_column in SeriesSplitter output table; otherwise, this value is from id column in InputTable.

n INTEGER or BIGINT Number of time points in individual time series.