TD_ACF Function Examples | Teradata Vantage - TD_ACF Examples - 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

Example: TD_ACF Call for Output Columns with Default Names

EXECUTE FUNCTION INTO VOLATILE ART(ACF_RESULTS)
TD_ACF(
   SERIES_SPEC(TABLE_NAME(OceanBuoy), SERIES_ID(BuoyID), ROW_AXIS(SEQUENCE(N_SeqNo)),
      PAYLOAD(FIELDS(MAGNITUDE), CONTENT(REAL))),
   FUNC_PARAMS( MAXLAGS(6), FUNC_TYPE(0), UNBIASED(0), DEMEAN(1), QSTAT(1), ALPHA(0.1))
);

TD_ACF Output

Display the RETURNS TABLE with this statement:

SELECT * FROM ACF_RESULTS
BuoyID ROW_I OUT_MAGNITUDE QSTATVAL_MAGNITUDE PVAL_MAGNITUDE CONF_OFF_MAGNITUDE CONF_LOW_MAGNITUDE CONF_HI_MAGNITUDE
----------- ----------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ----------------------
33 0 1.00000000000000E 000 0.00000000000000E 000 0.00000000000000E 000 0.00000000000000E 000 1.00000000000000E 000 1.00000000000000E 000
33 1 -1.82920791381904E-001 6.42432305659815E-001 4.22831394099169E-001 4.11213406737868E-001 -5.94134198119772E-001 2.28292615355964E-001
33 2 2.62334001926902E-001 2.05814009332348E 000 3.57339114803943E-001 4.24749816670561E-001 -1.62415814743659E-001 6.87083818597463E-001
33 3 -3.72557919734966E-001 5.13308072597631E 000 1.62307693275134E-001 4.51316462820762E-001 -8.23874382555729E-001 7.87585430857956E-002
33 4 1.34380264470074E-001 5.56647405747344E 000 2.33947855368904E-001 5.00627133532409E-001 -3.66246869062335E-001 6.35007398002483E-001
33 5 -9.71243668550373E-002 5.81345088287831E 000 3.24796282646804E-001 5.06689879071266E-001 -6.03814245926304E-001 4.09565512216229E-001
33 6 -1.66262176948171E-001 6.60957249360441E 000 3.58466156186571E-001 5.09828261003043E-001 -6.76090437951214E-001 3.43566084054872E-001

Example: TD_ACF Call for Output Columns with Specified Names

The COLUMNS clause specifies names for the output columns.

EXECUTE FUNCTION COLUMNS(OUT_MAGNITUDE AS ACF_SAL,
   QSTATVAL_MAGNITUDE AS QST_SAL, PVAL_MAGNITUDE AS PV_SAL) 
   INTO VOLATILE ART(ACF_RESULTS)
TD_ACF(
   SERIES_SPEC(TABLE_NAME(OceanBuoy), SERIES_ID(BuoyID),ROW_AXIS(SEQUENCE(N_SeqNo)),
      PAYLOAD(FIELDS(MAGNITUDE), CONTENT(REAL))),
   FUNC_PARAMS( MAXLAGS(6), FUNC_TYPE(0), UNBIASED(0), DEMEAN(1), QSTAT(1), ALPHA(0))
);

Display the RETURNS TABLE with this statement:

SELECT * FROM ACF_RESULTS;
BuoyID ROW_I ACF_SAL QST_SAL PV_SAL
----------- ----------- ---------------------- ---------------------- ----------------------
33 0 1.00000000000000E 000 0.00000000000000E 000 0.00000000000000E 000
33 1 -1.82920791381904E-001 6.42432305659815E-001 4.22831394099169E-001
33 2 2.62334001926902E-001 2.05814009332348E 000 3.57339114803943E-001
33 3 -3.72557919734966E-001 5.13308072597631E 000 1.62307693275134E-001
33 4 1.34380264470074E-001 5.56647405747344E 000 2.33947855368904E-001
33 5 -9.71243668550373E-002 5.81345088287831E 000 3.24796282646804E-001
33 6 -1.66262176948171E-001 6.60957249360441E 000 3.58466156186571E-001