DWT Input - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
9.02
9.01
2.0
1.3
Published
February 2022
Language
English (United States)
Last Update
2022-02-10
dita:mapPath
rnn1580259159235.ditamap
dita:ditavalPath
ybt1582220416951.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageâ„¢
Table Description
InputTable Function assumes that each sequence can be fitted into memory of worker.
WaveletFilterTable [Optional] If omitted, you must specify Wavelet syntax element.

InputTable Schema

Column Data Type Description
partition_column INTEGER, SMALLINT, BIGINT, NUMERIC, VARCHAR, VARBYTE(n), or BLOB [Column appears once for each specified partition_column.] Identifier of sequence to which data belongs. Rows with same partition column values belong to same sequence. If table has multiple partition columns, function treats first one as distribution key of OutputTable and MetaInformationTable.
sort_column Any Position of data in its sequence.
target_column INTEGER, SMALLINT, BIGINT, DOUBLE PRECISION, or NUMERIC Data to transform—numeric values between -1e308 and 1e308 (or NULL, which function treats as 0).

WaveletFilterTable Schema

Column Data Type Description
filtername VARCHAR Wave filtername from following table.
filtervalue VARCHAR Decomposed or reconstructed wavelet filter, represented as comma-separated sequence; conjugated scale coefficients for orthogonal wavelet. For details, see following table.

WaveletFilterTable Names and Values

filtername filtervalue
lowpassfilter Decomposed low-pass filter, represented as comma-separated sequence; conjugated scale coefficients for orthogonal wavelet. For example:

-0.1294095225512604, 0.2241438680420134, 0.8365163037378081, 0.4829629131445342

highpassfilter Decomposed high-pass filter, represented as comma-separated sequence; conjugated wavelet coefficients for orthogonal wavelet. For example:

-0.4829629131445342, 0.8365163037378081, -0.2241438680420134, -0.1294095225512604

ilowpassfilter Reconstructed low-pass filter, represented as comma-separated sequence; scale coefficients for orthogonal wavelet. For example:

0.4829629131445342, 0.8365163037378081, 0.2241438680420134, -0.1294095225512604

ihighpassfilter Reconstructed high-pass filter, represented as comma-separated sequence; wavelet coefficients for orthogonal wavelet. For example:

-0.1294095225512604, -0.2241438680420134, 0.8365163037378081, -0.4829629131445342