Input Table Schema
The table can have additional columns, but the function ignores them.
Column | Data Type | Description |
---|---|---|
partition_column | INTEGER, BIGINT, NUMERIC, or VARCHAR | Column by which input data is partitioned. This column must contain all rows that contain entity to average. For example, if function is to return exponential moving average of a particular stock share price, all transactions of that stock must be in one partition. |
order_column | INTEGER, BIGINT, TIME, or TIMESTAMP | Column by which input table is ordered. |
target_column | SMALLINT, INTEGER, BIGINT, NUMERIC, or DOUBLE PRECISION | [Column appears once for each specified target_column.] Values to average. |