1.1 - 8.10 - ChangePointDetection Output - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

The output table schema depends on the OutputOption syntax element.

Output Table Schema, OutputOption ('CHANGEPOINT') (Default)

The table has one row for each change point.

Column Data Type Description
accumulate_column Same as in input table [Column appears once for each specified accumulate_column.] Column copied from input table.
cptid INTEGER Changepoint identifier of sequence. For each partition, identifiers range from 1 to n, where n is the number of changepoints for the partition.

Output Table Schema, OutputOption ('VERBOSE')

The table has one row for each change point.

Column Data Type Description
accumulate_column Same as in input table [Column appears once for each specified accumulate_column.] Column copied from input table.
cptid INTEGER Changepoint identifier of sequence. For each partition, identifiers range from 1 to n, where n is the number of changepoints for that partition.
difference DOUBLE PRECISION Difference H 1 -H 0.

Output Table Schema, OutputOption ('SEGMENT')

The table has one row for each segment. For k changepoints, there are k+1 segments.

Column Data Type Description
accumulate_column# Any [Column appears once for each specified accumulate_column.] Segment starting point.
accumulate_column Same as in input table [Column appears once for each specified accumulate_column.] Column copied from input table.
segid INTEGER Segment identifier.