Input
- Output table of ChangePointDetection Example 2: One Series, Default Options
SQL Call
SELECT * FROM ChangePointDetection ( ON cpt PARTITION BY sid ORDER BY id USING ValueColumn ('val') Accumulate ('sid', 'id') Penalty (20) SegmentationMethod ('linear_regression') ) AS dt;
Output
sid | id | cptid |
---|---|---|
1 | 11 | 1 |
1 | 21 | 2 |
1 | 31 | 3 |