The input table must have the rows described in the following table. The table can have additional rows, but the function ignores them.
| Column Name | Data Type | Description |
|---|---|---|
| partition_column | Any | Column by which the input table is partitioned. Each partition must include all rows of an entity. For example, to compute the exponential moving average of a particular stock share price, all transactions of that stock must be in the same partition. |
| order_column | TIME, TIMESTAMP, INTEGER, SMALLINT, or BIGINT | Column by which to order the input. |
| input_column | INTEGER, SMALLINT, BIGINT, or DOUBLE PRECISION | Input column for which the exponential moving average is to be computed. |