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) ) AS dt ORDER BY sid, id;
Output
sid | id | cptid |
---|---|---|
1 | 11 | 1 |
1 | 21 | 2 |
1 | 31 | 3 |