Changes and Additions - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-04-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743
Date Release Description
August 2024 17.20.03.29 The following changes were done:
  • Updated TD_DICKEY_FULLER ALGORITHM and MAXLAGS parameters, removed DRIFT_TREND_FORMULA parameter.
  • Updated TD_GOLDFELD_QUANDT FUNC_PARAMS list and DEGREES_FREEDOM names.
October 2023 17.20.03.18 The following functions were added:
  • TD_IQR uses interquartile range to identify data points, events and observations that deviate from the normal behavior of the data set. See TD_IQR.
  • TD_DWT performs discrete wavelet transform (DWT) for digital signal processing. See TD_DWT.
  • TD_DWT2D performs DWT for two-dimensional data, such as an image. See TD_DWT2D.
  • TD_IDWT performs inverse discrete wavelet transform (IDWT) for digital signal processing. See TD_IDWT.
  • TD_IDW2D performs IDWT for two-dimensional data, such as an image. See TD_IDWT2D.
August 2023 17.20.03.16 The following functions were added:
June 2023 17.20.03.13 The following change was done:
  • Updated TD_PORTMAN functional parameter description and output description for DEGREES_FREEDOM.
May 2023 17.20.03.13 The following changes were done:
  • Updated the TD_HOLT_WINTERS_FORECASTER option RESIDUALS description to show it is optional.
April 2023 17.20.03.13 The following changes were done:
  • TD_ ARIMAESTIMATE and TD_ ARIMAVALIDATE added OUTPUT_FMT to syntax and descriptions.
  • TD_ARIMAFORECAST added PREDICTION_INTERVALS and OUTPUT_FMT to syntax and descriptions.
  • TD_ARIMAVALIDATE FUNC_PARAM parameters are optional.
  • TD_ARIMAESTIMATE COEFF_STATS is optional.
  • TD_SIGNIF_PERIODICITIES SIGNIFICANCE_LEVEL is optional.
  • TD_BREUSCH_GODFREY SIGNIFICANCE_LEVEL is optional. The default is 0.05.
  • TD_DURBIN_WATSON INCLUDE_CONSTANT is optional.
  • TD_INPUTVALIDATOR syntax added VALIDATE_PAYLOAD. It is optional.
  • TD_ACF FUNC_PARAMS description for DEMEAN added "If DEMEAN(0), then PVALUE is 0 for all auto-correlation or auto-covariance coefficients in the output."
  • TD_RESAMPLE SPLINE_PARAMS are optional.
  • The example for TD_ARIMAVALIDATE changed to FLOW_THROUGH.
June 2022 17.20.00 Initial release