7.00.02 - DWT2D Arguments - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17
InputTable
Specifies the name of the table or view that contains the sequences to be transformed.
OutputTable
Specifies the name for the table that the function creates to store the coefficients generated by the wavelet transform. This table must not exist.
MetaTable
Specifies the name for the table that the function creates to store the meta information for the wavelet transform. This table must not exist.
InputColumns
Specifies the names of the columns in the input table or view that contain the data to be transformed. These columns must contain numeric values between -1e308 and 1e308. The function treats NULL as 0.
PartitionColumns
[Optional] Specifies the names of the 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 output and meta tables.

Default behavior: All rows belong to one sequence, and the function generates a distribute key column named dwt_idrandom_name in both the output table and the meta table. In both tables, every cell of dwt_idrandom_name has the value 1.

IndexColumns
Specifies 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.
Range
[Optional] Specifies the start and end indexes of the input data, all of which must be integers. Default:The values for each sequence are:
  • starty : minimum y index
  • startx : minimum x index
  • endy : maximum y index
  • endx : maximum x index

The function treats any NULL value as 0.

The range can specify a maximum of 1,000,000 cells.

Wavelet
[Optional] Specifies a wavelet filter name from the table, Supported Wavelet Filter Names, in the Arguments section of the DWT function.
WaveletFilterTable
[Optional] Specifies the name of the table that contains the coefficients of the wave filters.
Level
Specifies the wavelet transform level. The value level must be an integer in the range [1, 1000].
ExtensionMode
[Optional] Specifies the method for handling border distortion, an extension_mode from the table, Supported Extension Modes, in the Arguments section of the DWT function. Default: 'sym'.
CompactOutput
[Optional] Specifies 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.