1.0 - 8.00 - ChangePointDetection Example 3: One Series, VERBOSE Output - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

SQL Call

SELECT * FROM ChangePointDetection (
  ON cpt PARTITION BY sid ORDER BY id
  USING
  ValueColumn ('val')
  Accumulate ('sid', 'id')
  OutputOption ('VERBOSE')
) AS dt ORDER BY sid, id;

Output

sid id cptid difference
1 8 1 7.47347903247601
1 11 2 97.3574610687669
1 21 3 48.6750178281853
1 31 4 52.088392576252
1 34 5 3.71888507066399