1.1 - 8.10 - DWT2D Syntax Elements - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Teradata Vantage
Release Number
Release Date
October 2019
Content Type
Programming Reference
Publication ID
English (United States)
Specify the name for the table that the function creates to store the coefficients output by the wavelet transform. This table must not exist.
Specify the name for the table that the function creates to store the meta information for the wavelet transform. This table must not exist.
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.
[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 MetaInformationTable.
The DWT2D output tables are the IDWT2D input 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 MetaInformationTable. In both tables, every cell of dwt_id_random_name has the value 1.
Specify the columns that contain the indexes of the input sequences. For a matrix, indexy_column contains the y coordinates and indexx_column contains the x coordinates.
[Optional] Specify the start and end indexes of the input data, all of which must be integers. The range can specify a maximum of 1,000,000 cells. The function treats any NULL value as 0.
Index Default
starty minimum y index
startx minimum x index
endy maximum y index
endx maximum x index
[Required if you omit WaveletFilterTable] Specify a wavelet filter name from the table Supported Wavelet Filter Names in DWT Syntax Elements.
Specify the wavelet transform level. The value level must be an integer in the range [1, 1000].
[Optional] Specify the method for handling border distortion, an extension_mode from the table Supported Extension Modes in DWT syntax elements.
Default: 'sym'
[Optional] Specify whether to ignore rows in which all coefficient values have an absolute value less than 1e-12).
Default: 'true'. For a sparse input matrix, ignoring such rows reduces the output table size.