1.1 - 8.10 - IDWT2D Syntax Elements - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)
OutputTable
Specify the name for the table that the function creates to store the reconstructed result. This table must not exist.
TargetColumns
Specify the names of the InputTable columns that contain the data to transform. These columns must contain numeric values between -1e308 and 1e308. The function treats NULL as 0.
SortColumn
Specify the name of the InputTable column that represents the order of coefficients in each sequence (the waveletid column in the DWT2D output table). The column must contain a sequence of integer values that start from 1 for each sequence. If a value is missing from the sequence, the function treats the corresponding data column as 0.
PartitionColumns
[Optional] Specify the names of the InputTable partition columns, which identify the sequences. Rows with the same partition column values belong to the same sequence. If you specify multiple partition columns, the function treats the first one as the distribute key of the OutputTable and MetaTable.
The IDWT2D input tables are the DWT2D output tables. If you specify this syntax element for DWT2D, you must also specify it for IDWT2D; otherwise, the results might not make sense.
Default behavior: All rows belong to one sequence, and the function creates a distribute key column named dwt_id_random_name in both the OutputTable and MetaTable. In both tables, every cell of dwt_id_random_name has the value 1.
VerboseFlag
[Optional] Specify whether to ignore (not output) rows in which all coefficient values have an absolute value less than 1e-12). For a sparse input matrix, ignoring such rows reduces the output table size.
Default: 'true'