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') Granularity (5) ) AS dt;
Output
sid | id | cptid -----+----+------- 1 | 8 | 1 1 | 10 | 2 1 | 22 | 3 1 | 24 | 4 1 | 29 | 5 1 | 31 | 6 1 | 33 | 7
Download a zip file of all examples and a SQL script file that creates their input tables.