ChangePointDetection Example 5: One Series, SEGMENT Output, Penalty 10 - Teradata Vantage

Input

• Output table of ChangePointDetection Example 2: One Series, Default Options

SQL Call

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

Output