TD_RESAMPLE Syntax Elements - Teradata Vantage

Teradata® VantageCloud Lake

Deployment

VantageCloud

Edition

Lake

Product

Teradata Vantage

Published

January 2023

ft:locale

en-US

ft:lastEdition

2024-12-11

dita:mapPath

phg1621910019905.ditamap

dita:ditavalPath

pny1626732985837.ditaval

dita:id

phg1621910019905

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.