Input
- InputTable: burst_example from Burst Example: TimeInterval, SplitCriteria ('nosplit')
SQL Call
SELECT * FROM Burst ( ON burst_example AS InputTable 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 ;
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.0 2010-08-01 2010-08-02 86400.0 1 200.0 2010-08-02 2010-08-03 86400.0 1 283.3333333333333 2010-08-03 2010-08-04 86400.0 1 133.33333333333331 2010-08-04 2010-08-05 86400.0 1 213.33333333333331 2010-08-05 2010-08-06 86400.0 1 213.33333333333331 2010-08-06 2010-08-07 86400.0 1 213.33333333333331 2010-08-07 2010-08-08 86400.0 1 163.33333333333331 2010-08-08 2010-08-09 86400.0 1 80.0 2010-08-09 2010-08-10 86400.0
Download a zip file of all examples and a SQL script file that creates their input tables.