Input Table Schema
Column | Data Type | Description |
---|---|---|
partition_column | Any | Column by which input data is partitioned. This column must contain all rows of an entity. For example, if function is to compute moving average of a particular stock share price, all transactions of that stock must be in one partition. PARTITION BY clause assumes column names are in Normalization Form C (NFC). |
order_column | Any | Column by which input table is ordered. ORDER BY clause supports only ASCII collation. |
target_column | INTEGER, SMALLINT, BIGINT, NUMERIC, NUMBER, or DOUBLE PRECISION | Values to average. |