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 A n , H n , V n , D n , H n-1 , ..., H 1 , V 1 , D 1 , 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 input and output tables. If InputTable has only one partition column, output table 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 | Pairs that represent length of each block of coefficients. Format: (row_number, column_number) Example: (5, 5), (5, 5), (5, 6) |
length | Pair that represents length of original sequence in each dimension. Format: (row_number, column_number) Example: (5, 8) |
range | Minimum and maximum indexes of original sequence. Format: (min_y_index, min_x_index), (max_y_index, max_x_index) Example: (1, 1), (5, 8) |
lowpassfilter | Low-pass filter coefficients used in wavelet decomposition. |
highpassfilter | High-pass filter coefficients used in wavelet decomposition. |
ilowpassfilter | Low-pass filter coefficients used in wavelet reconstruction. |
ihighpassfilter | High-pass filter coefficients used in wavelet reconstruction. |
level | Level of wavelet transform. |
extensionmode | Extension mode used in wavelet transform. |