TD_MAMEAN Syntax Elements - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743
lifecycle
latest
SERIES_SPEC
An input source with the univariate series instances to be processed by the function. The data type is REAL.

See Series Specifications.

FUNC_PARAMS
Name Data Type Description
FORECAST_PERIODS Integer Number of periods to forecast. It is an integer between 1 to 32000.
ALGORITHM Enum, String Type of forecast algorithm to use.
  • MA: Moving Average
  • MEAN: Mean average
  • NAIVE: Naive, also known as random walk forecast
PREDICTION_INTERVALS Enum, String [Optional] The confidence level for the prediction, such that 85 means 85% confidence.
  • NONE
  • 85
  • 90
  • BOTH

Default is BOTH 85 and 90.

FIT_METRICS Integer [Optional] Flag to generate the secondary result set that contains the model metadata statistics. A value of 1 means generate the secondary result set. A value of 0 means do not generate the secondary result set. The default is 0.

The generated result set is retrieved using TD_EXTRACT_RESULTS against the analytical result table containing the results.

RESIDUALS Integer [Optional] Flag to generate the tertiary result set that contains the model residuals. A value of 1 means generate the tertiary result set. A value of 0 means do not generate the tertiary result set. Th default value is 0.

The generated result set is retrieved using TD_EXTRACT_RESULTS against the analytical result table containing the results.

K_ORDER Integer [Dependencies: Only used with ALGORITHM(MA), and required.] Integer between 1 to 32000.
INPUT_FMT
No INPUT_FMT options are available for this function.
OUTPUT_FMT
No OUTPUT_FMT options are available for this function.