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 (10) WindowSize (3) Accumulate ('sid', 'id') ) AS dt;
Output
sid id cptid --- -- ----- 1 11 1 1 21 2 1 31 3 1 36 4
Download a zip file of all examples and a SQL script file that creates their input tables.