The Interpolator function has three input tables:
- 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.
| 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.
| 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.
| 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. |