Output Message Schema
Column | Data Type | Description |
---|---|---|
messages | VARCHAR | Reports whether function succeeded. |
OutputTable Schema
The table has reconstructed 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 input and output tables. If InputTable has only one partition column, output table has as its distribution key a function-created column named dwt_idrandom_name. Every cell of dwt_idrandom_name has the value 1. |
indexid | INTEGER | Index of each reconstructed sequence (starting from 1 for each sequence). |
input_column | INTEGER, SMALLINT, BIGINT, DOUBLE PRECISION, or NUMERIC | [Column appears once for each input_column.] Reconstructed sequence. |