Table | Description |
---|---|
InputTable | Function assumes that each sequence can be fitted into memory of worker. |
WaveletFilterTable | [Optional] If omitted, you must specify Wavelet syntax element. |
InputTable Schema
The table can have additional columns, but the function ignores them.
Column | Data Type | Description |
---|---|---|
partition_column | INTEGER, SMALLINT, BIGINT, NUMERIC, VARCHAR, VARBYTE(n), or BLOB | [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 table has multiple partition columns, function treats first one as distribution key of OutputTable and MetaInformationTable. |
sort_column | Any | Position of data in its sequence. |
target_column | INTEGER, SMALLINT, BIGINT, DOUBLE PRECISION, or NUMERIC | Data to transform—numeric values between -1e308 and 1e308 (or NULL, which function treats as 0). |
WaveletFilterTable Schema
Column | Data Type | Description |
---|---|---|
filtername | VARCHAR | Wave filtername from following table. |
filtervalue | VARCHAR | Decomposed or reconstructed wavelet filter, represented as comma-separated sequence; conjugated scale coefficients for orthogonal wavelet. For details, see following table. |
WaveletFilterTable Names and Values
filtername | filtervalue |
---|---|
lowpassfilter | Decomposed low-pass filter, represented as comma-separated sequence; conjugated scale coefficients for orthogonal wavelet. For example: -0.1294095225512604, 0.2241438680420134, 0.8365163037378081, 0.4829629131445342 |
highpassfilter | Decomposed high-pass filter, represented as comma-separated sequence; conjugated wavelet coefficients for orthogonal wavelet. For example: -0.4829629131445342, 0.8365163037378081, -0.2241438680420134, -0.1294095225512604 |
ilowpassfilter | Reconstructed low-pass filter, represented as comma-separated sequence; scale coefficients for orthogonal wavelet. For example: 0.4829629131445342, 0.8365163037378081, 0.2241438680420134, -0.1294095225512604 |
ihighpassfilter | Reconstructed high-pass filter, represented as comma-separated sequence; wavelet coefficients for orthogonal wavelet. For example: -0.1294095225512604, -0.2241438680420134, 0.8365163037378081, -0.4829629131445342 |