| 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
The table can have additional columns, but the function ignores them.
| 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.