Table | Description |
---|---|
InputTable | Required by both versions. |
MeanStats | Required by multiple-input version, disallowed by single-input version. |
STDevStats | Required by multiple-input version, disallowed by single-input version. |
InputTable Schema
Column | Data Type | Description |
---|---|---|
target_column | BYTEINT, SMALLINT, INTEGER, BIGINT, NUMERIC, or DOUBLE PRECISION | [Column appears one or more times.] Time series data to transform. |
time_column | BYTEINT, SMALLINT, INTEGER, BIGINT, NUMERIC, or DOUBLE PRECISION | [Column appears only with TimeColumn syntax element.] Time axis of data. |
accumulate_column | Any | [Column appears once for each specified accumulate_column.] Column to copy to output table. |
MeanStats Schema
The MeanStats table must have every target_column and partition column (in key) that InputTable has.
The MeanStats table has the global means of each target_column of InputTable. Each row of the MeanStats table specifies the global means for one input partition.
STDevStats Schema
The STDevStats table must have every target_column and partition column (in key) that InputTable has.
The STDevStats table has the global standard deviations of each target_column of InputTable. Each row of the STDevStats table specifies the global means for one input partition.