DWT Output - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
9.02
9.01
2.0
1.3
Published
February 2022
Language
English (United States)
Last Update
2022-02-10
dita:mapPath
rnn1580259159235.ditamap
dita:ditavalPath
ybt1582220416951.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

Output Message Schema

Column Data Type Description
messages VARCHAR Reports whether function succeeded.

OutputTable Schema

The table has decomposed sequences.

Column Data Type Description
partition_column Same as in input table [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 InputTable has multiple partition columns, first one is distribution key in both InputTable and OutputTable.

If InputTable has only one partition column, OutputTable has as its distribution key a function-created column named dwt_id_random_name. Every cell of dwt_id_random_name has the value 1.

waveletid INTEGER Index of each wavelet coefficient (starting from 1 for each sequence).
waveletcomponent VARCHAR Component to which coefficient belongs. Possible values are An, Dn, Dn-1, ..., D1, where n is wavelet transform level.
target_column DOUBLE PRECISION [Column appears once for each target_column.] Coefficient of input column after wavelet transform.

MetaInformationTable Schema

Column Data Type Description
partition_column Same as in input table [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 InputTable has multiple partition columns, first one is distribution key in both InputTable and OutputTable.

If InputTable has only one partition column, OutputTable has as its distribution key a function-created column named dwt_id_random_name. Every cell of dwt_id_random_name has the value 1.

meta VARCHAR Name from meta column of following table.
content VARCHAR Content from content column of following table.

Meta Information for Each Sequence

meta content
blocklength Length of each component after transformation, from An to D1. Example: 8, 8, 13
length Length of sequence before transformation. Example: 24
waveletname Name of wavelet used in transformation. Example: db2
lowpassfilter Low-pass filter used in wavelet decomposition.
highpassfilter High-pass filter used in wavelet decomposition.
ilowpassfilter Low-pass filter used in wavelet reconstruction.
ihighpassfilter High-pass filter used in wavelet reconstruction.
level Level of wavelet transform.
extensionmode Extension mode used in wavelet transform.