TD_LINESPEC

The Line Spectrum function is one of the tools that the data scientist may employ in identifying periodicities that may be inherent in the dataset

Options

FREQ_STYLE: FREQ_STYLE(K_INTEGRAL) - The ROW_AXIS scale if frequency: fk = 0, 1,2,…N/2 or (N-1)/2FREQ_STYLE(K_SAMPLE_RATE) - The ROW_AXIS scale if frequency: fk = k/N = wk/2π = 1/P FREQ_STYLE(K_RADIANS) - The ROW_AXIS scale if angular frequency: wk = 2πk/N = 2πfk = 2π/P FREQ_STYLE(K_PERIODICITY) - Periodicity = P = 1/fk = 2π/wk = N/k
HERTZ_SAMPLE_RATE: Optional Parameter. Only valid with a FREQ_STYLE(K_HERTZ). A Floating point constant representing the sample rate, in hertz. A value of 10000.0 means that the sample points were obtained by sampling at a rate of 10,000 hertz.
INCLUDE_COEFF: Flag indicating whether the data scientist wishes to include the calculated, αk and βk, values with the results.
Output Schema: Output Schema, if Volatile is true then use user login as the schema.
Output Table: Output Table
VAL Location: VAL Location
Volatile: Specifies whether the table should be a VOLATILE table. If true, then the table is automatically deleted, otherwise it is users responsibility to remove or clean it up for space.
ZERO_PADDING_OK: Determines whether it is OK to add zeros to the end of a given Series to achieve a more efficient computation of the FFT coefficients. A value of '1' means true; a value of '0' means false. Default is true.

: Connection to a Teradata Database Instance
: At its core, this function takes a logical-runtime series as an input and transforms the series from the time or spatial domain to the temporal frequency or spatial frequency domain, respectively. The input series can be composed of individual elements which are of type real (PAYLOAD(CONTENT(REAL))), multi-variate real (PAYLOAD(CONTENT(MULTIVAR_REAL))).