TD_LINESPEC Syntax Elements - 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
2026-03-23
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743
SERIES_SPEC (time_series)
A univariate or multivariate series instances.

See Series Specifications.

FUNC_PARAMS
Name Data Type Description
FREQ_STYLE String

[Optional] The format or values associated with the x-axis of the output.

Choices are:
  • K_INTEGRAL: Integer representation.
  • K_SAMPLE_RATE: Integer normalized to number entries, with ranges from -0.5 to +0.5.
  • K_RADIANS: Radian ranges from -π to +π.
  • K_PERIODICITY: Periodicity.
  • K_HERTZ: Used with the parameter HERTZ_SAMPLE_RATE to compute the frequency scale in terms of hertz.

The default is K_INTEGRAL.

INCLUDE_COEFF INTEGER [Optional] Indicator to include the calculated αk and βk value columns in the primary result set. A value of 1 includes the columns and a value of 0 does not include the columns. The default value is 0, do not include.

The formula for the magnitude at time k in the line spectrum is:

(n/2) * (( αk)2 + (βk)2)

ZERO_PADDING_OK INTEGER [Optional] Indicator to add zeros to the end of the series instances to make computation more efficient. The value of 0 does not add zeroes. A value of 1 does add zeroes. The default is 1. For best performance, let this parameter default to 1.
HERTZ_SAMPLE_RATE FLOAT [Dependencies: Only used and required with K_HERTZ.] The sample rate as a floating point constant, in hertz. A value of 10000.0 indicates that the sample points were obtained by sampling at a rate of 10,000 hertz.
INPUT_FMT
No INPUT_FMT options are available for this function.
OUTPUT_FMT
No OUTPUT_FMT options are available for this function.