Input
- Output table of ChangePointDetection Example: One Series, Default Options
SQL Call
SELECT * FROM ChangePointDetectionRT ( ON cpt PARTITION BY sid ORDER BY id USING TargetColumn ('val') ChangePointThreshold (100) WindowSize (3) Accumulate ('sid', 'id') ) 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.