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.