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