The DWT function outputs a message that indicates whether the function succeeded, an output table of transformed (decomposed) sequences, and a meta table of wavelet-related information.
Column Name | Data Type | Description |
---|---|---|
messages | VARCHAR | Message that indicates whether the function was successful. |
Column Name | Data Type | Description |
---|---|---|
partition_column | Inherited from input table column with same name | Sequence identifier of the sequence to which the data belongs. Rows with the same partition column values belong to the same sequence. The output table has a partition_column for every partition_column in the input table. If the input table has multiple partition columns, the first one is the distribute key in both the input and output tables. If the input table has only one partition_column, the output table has as its distribute key a function-generated column named dwt_idrandom_name. Every cell of dwt_idrandom_name has the value 1. |
waveletid | INTEGER | Index of each wavelet coefficient (starting from 1 for each sequence). |
waveletcomponent | VARCHAR | Component to which the coefficient belongs. Possible values are A n , D n , D n-1 , ..., D 1, where n is the wavelet transform level. |
input_column | DOUBLE PRECISION | Coefficient of the corresponding input column after the wavelet transform. The output table has an input_column for every input_column in the input table. |
Column Name | Data Type | Description |
---|---|---|
partition_column | Inherited from input table column with same name | Contains the sequence identifier of the sequence to which the data belongs. Rows with the same partition column values belong to the same sequence. The meta table has a partition_column for every partition_column in the input table. If the input table has multiple partition columns, the first one is the distribute key in both the input and meta tables. If the input table has only one partition_column, the meta table has as its distribute key a function-generated column named dwt_idrandom_name. Every cell of dwt_idrandom_name has the value 1. |
meta | VARCHAR | Meta information name from the following table. |
content | VARCHAR | Meta information that corresponds to the meta name (see the following table). |
The following table summarizes the information that the meta table contains for each sequence.
meta | content |
---|---|
blocklength | Length of each component after transformation, from A n to D 1. For example: 8, 8, 13 |
length | Length of the sequence before transformation. For example: 24 |
waveletname | Name of the wavelet used in the transformation. For example: db2 |
lowpassfilter | Low-pass filter used in the decomposition of the wavelet. |
highpassfilter | High-pass filter used in the decomposition of the wavelet. |
ilowpassfilter | Low-pass filter used in the reconstruction of the wavelet. |
ihighpassfilter | High-pass filter used in the reconstruction of the wavelet. |
level | Level of wavelet transform performed. |
extensionmode | Extension mode used in the wavelet transform. |