DWT Input - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.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

The table can have additional columns, but the function ignores them.

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