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 (10) OutputOption ('SEGMENT') ) AS dt ORDER BY sid, id;
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 |