TD_POWERSPEC 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
2025-04-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.