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) OutputType ('SEGMENT') ) AS dt;
Output
sid_s id_s sid id segid ----- ---- --- -- ----- 1 1 1 10 1 1 11 1 20 2 1 21 1 30 3 1 31 1 40 4
Download a zip file of all examples and a SQL script file that creates their input tables.