7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17

The Interpolator function has one output table, which contains the time series with the values that the function calculated. Each row contains one time point in the series and one or more values. The following table describes the output table. Columns copied from input_table appear in the same order in the output table.

Interpolator Output Table Schema
Column Data Type Description
time_column INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, DECIMAL(n,n), DECIMAL, NUMERIC, NUMERIC(n,n), DATE, TIME, TIME(n), TIME WITH TIME ZONE, TIME WITH TIME ZONE(n), TIMESTAMP, TIMESTAMP(n), TIMESTAMP WITH TIME ZONE, or TIMESTAMP WITH TIME ZONE(n) Contains the time points in the time series. This column corresponds to time_column in input_table.
value_column INTEGER, BIGINT, SMALLINT, DOUBLE PRECISION, DECIMAL(n,n), DECIMAL, NUMERIC, NUMERIC(n,n), CHARACTER, CHARACTER(n), CHARACTER VARYING, CHARACTER VARYING(n), or VARCHAR
For data types CHARACTER, CHARACTER(n), CHARACTER VARYING, CHARACTER VARYING(n), and VARCHAR, the only supported interpolation type is 'constant'.
Contains values for the time points in time_column. This column corresponds to a value_column in input_table. The table can have more than one such column.
accumulate_column Any Column copied from input_table, specified by the Accumulate argument.

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