Input
- input_table: burst_example from Burst Example 1: TimeInterval, SplitCriteria ('nosplit')
SQL Call
SELECT * FROM Burst ( ON burst_example AS input_table PARTITION BY id ORDER BY id USING TimeColumn ('start_time_column', 'end_time_column') TimeInterval (86400) TargetColumns ('num_custs') StartTime ('08/01/2010') EndTime ('08/10/2010') SplitCriteria ('proportional') Accumulate ('id') ) AS dt ORDER BY id;
Output
The value assigned to each subinterval is determined by dividing the value from each row by the number of subintervals in the row. For example, the value assigned to 2010-08-06 is based on the first 3 rows of the input table: 400/5 + 500/6 + 200/4 = 80 + 83.33 + 50 = 213.33
id | num_custs | burst_start | burst_end | burst_duration |
---|---|---|---|---|
1 | 200 | 2010-08-01 | 2010-08-02 | 86400 |
1 | 200 | 2010-08-02 | 2010-08-03 | 86400 |
1 | 283.333333333333 | 2010-08-03 | 2010-08-04 | 86400 |
1 | 133.333333333333 | 2010-08-04 | 2010-08-05 | 86400 |
1 | 213.333333333333 | 2010-08-05 | 2010-08-06 | 86400 |
1 | 213.333333333333 | 2010-08-06 | 2010-08-07 | 86400 |
1 | 213.333333333333 | 2010-08-07 | 2010-08-08 | 86400 |
1 | 163.333333333333 | 2010-08-08 | 2010-08-09 | 86400 |
1 | 80 | 2010-08-09 | 2010-08-10 | 86400 |