ChangePointDetection Example: One Series, Cost 10 - Teradata Vantage

Input

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

SQL Call

SELECT * FROM ChangePointDetection (
  ON cpt PARTITION BY sid ORDER BY id
  USING
  TargetColumn ('val')
  Accumulate ('sid', 'id')
  Cost (10)
) AS dt;

Output

 sid id cptid 
 --- -- ----- 
   1 11     1
   1 21     2
   1 31     3

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.