7.00.02 - Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
The Interpolator function has these input tables:
Input Table Comment
input_table  
time_table [Optional] If you omit time_table, you must specify the TimeInterval argument. The choice of TimeInterval or time_table affects the behavior of interpolation, but not aggregation. For details, see the descriptions of the InterpolationType and AggregationType arguments.
count_row_number [Optional] Use count_row_number only with InterpolationType('loess'(weights ({constant | tricube}), degree ({0 |1 |2}), span(m))), where m is between (λ+1)/n and 1.

The input_table contains the time series whose missing values are to be calculated. Each row contains one time point in the series and one or more values. The following table describes the input_table columns that you can specify in function arguments.

Interpolator input_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.
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.

The table can have more than one such column.

accumulate_column Any Column to be copied to the output table, specified by the Accumulate argument.

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

The time_table consists of a single column, which contains the time points whose values are to be calculated. The following table describes time_table.

Interpolator time_table Schema
Column Data Type Description
time_column Data type of time_column in input_table Contains the time points in the time series whose missing values are to be calculated.

The count_row_number table contains information about the shorter time intervals into which the original time series (in input_table) has been split. Each row represents one shorter time interval. The following table describes time_table.

Interpolator count_row_number Table Schema
Column Data Type Description
id INTEGER or VARCHAR if id is from SeriesSplitter output table; otherwise, any data type Contains the identification number of the shorter time interval.

If the shorter time intervals are produced by the function SeriesSplitter, this column has the value of split_id_column in the SeriesSplitter output table; otherwise, this column has the value of the id column in input_table.

n INTEGER or BIGINT Contains the number of data points in the individual time series.