DWT2D 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â„¢

The DWT2D function has a required input table (or view) and an optional wavelet filter table. If you omit the wavelet filter table, you must specify the Wavelet argument.

The function assumes that each sequence fits into the memory of the worker. The following table describes the input table columns that you can or must specify with arguments. The table can have additional columns, but the function ignores them.

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.
indexy INTEGER Y index of sequence to which data belongs. If this column value is NULL, function ignores row.
indexx INTEGER X index of sequence to which data belongs. If this column value is NULL, function ignores row.
input_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

Same as WaveletFilterTable Schema in DWT Input.