TD_LINESPEC 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
2024-10-04
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.