DWT Input - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.00
1.0
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageâ„¢
Table Description
InputTable Has at most 1594 columns. Function assumes that each sequence can be fitted into memory of worker.
WaveletFilterTable [Optional] If omitted, you must specify Wavelet argument.

InputTable Schema

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

Column Data Type Description
partition_column INTEGER, SMALLINT, BIGINT, NUMERIC, VARCHAR, or VARBYTE(n) [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 output and meta tables.
sort_column INTEGER, SMALLINT, BIGINT, DOUBLE PRECISION, NUMERIC, TIME, or TIMESTAMP 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