TD_POWERSPEC 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.
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.
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.
ALGORITHM String [Optional] The algorithm to calculate the power spectrum. Options are as follows:
  • AUTOCORR: Use the Fourier Cosine of the Auto correlation approach.
  • AUTOCOV: Use the Fourier Cosine of the Auto covariance approach to calculate power spectrum
  • FOURIER: Use the Fourier Transform approach.
  • INCRFOURIER: Use the Incremental Fourier Transform approach.
INCRFOURIER_PARAM Integer list [Dependencies: Only used and required with ALGORITHM(INCRFOURIER).] The spacing interval (K) and interval sampling lengths (L).
SPACING_INTERVAL INTEGER [Dependencies: Only used and required with INCRFOURIER (and ALGORITHM(INCRFOURIER).]

The number of sample points per interval.

INTERVAL_LENGTH INTEGER [Dependencies: Only used and required with INCRFOURIER and ALGORITHM(INCRFOURIER).]

The number of sample points in the overlapping interval.
WINDOW String [Optional] The type of smoothing window to use. Use NONE to not apply a smoothing window.

When WINDOW is used, it must be used with the parameter WINDOW_NAME to identify the type of window to apply.

Default is to use WINDOW_NAME(NONE).
WINDOW_NAME String [Dependencies: Only used and required with WINDOW.] Apply a smoothing window. Options are as follows:
  • TUKEY: Apply a Tukey smoothing window with the supplied alpha value. Must use with WINDOW_PARAM.
  • BARTLETT: Apply a Bartlett smoothing window.
  • PARZEN: Apply a Parzen smoothing window.
  • WELCH: Apply a Welch smoothing window.

    NONE: Do not apply a window. This causes a square wave window, which has a magnitude of 1.0 for the whole duration of the window.
WINDOW_PARAM INTEGER [Dependencies: Only used and required with WINDOW and WINDOW_NAME(TUKEY).] The alpha parameter to use with Tukey smoothing window.
INPUT_FMT
No INPUT_FMT options are available for this function.
OUTPUT_FMT
No OUTPUT_FMT options are available for this function.