TD_RESAMPLE 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
2023-12-08
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743
SERIES_SPEC
Univariate or multivariate series containing real numbers as elements.

See Series Specifications.

FUNC_PARAMS
Name Data Type Description
TIMECODE / SEQUENCE Record Result series based on the index data type of the input series. The parameter defines the following for the series:
  • Starting value: The first sampling index that the resample function is to interpolate.
  • Sampling duration: The sampling interval associated with the result series.

At least one of TIMECODE or SEQUENCE must be present, and must correspond correctly to the index data type of the input series. They are mutually exclusive.
INTERPOLATE Enum, String One of the valid supported interpolation strategies. Options are as follows:
  • LINEAR
  • LAG
  • LEAD
  • WEIGHTED
  • SPLINE
WEIGHT FLOAT [Dependencies: Only used and required with INTERPOLATE (WEIGHTED) Interpolated weighted value. .
SPLINE_PARAMS Record [[Dependencies: Only used in conjunction and required with INTERPOLATE(SPLINE).] This is used to specify characteristics of the generated spline.
SPLINE_PARAMS (METHOD) Enum, String [Optional] Type of spline method to use. The following options are available:
  • CLAMPED
  • NATURAL
  • NOT_A_KNOT

Default is NOT_A_KNOT.
SPLINE_PARAMS (yp1) FLOAT [Dependencies: Only used and optional with METHOD (CLAMPED). ] Value of the first derivative for the left boundary condition. The default value is 0 (zero).
SPLINE_PARAMS (ypn) FLOAT [Dependencies: Only used and optional with METHOD (CLAMPED). ] Value of the first derivative for the right boundary condition. The default value is 0 (zero).
INPUT_FMT
No INPUT_FMT options are available for this function.
OUTPUT_FMT
[Optional] The INDEX_STYLE of the output format. Options are NUMERICAL_SEQUENCE and FLOW_THROUGH. The default is FLOW_THROUGH.
time-zero-value
[Dependencies: Required when indexing is TIMECODE based.] Starting time for a time interpolation resampling.
time-duration
[Dependencies: Required when indexing is TIMECODE based.] Time duration for a time interpolation resampling.
index-zero-value
[Dependencies: Required when indexing is SEQUENCE based.] Index zero value to use as a reference point to determine the starting point for a sequence interpolation resampling.
index-offset
[Dependencies: Required when indexing is SEQUENCE based.] Offset for a sequence interpolation resampling.