IDWT Output - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.00
1.0
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.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 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.