| Table | Description |
|---|---|
| input | 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. |
input 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 | [Appears only with TimeColumn argument.] 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 the input table has.
The meanstats table has the global means of each target_column of the input table. 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 the input table has.
The stdevstats table has the global standard deviations of each target_column of the input table. Each row of the stdevstats table specifies the global means for one input partition.