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 ('gaussian') Accumulate ('id') ) AS dt;
Output
The num_custs column values can vary, due to the random component of the calculation. For details, see the description of SplitCriteria in Burst Syntax Elements.
id num_custs burst_start burst_end burst_duration -- --------- ----------- ---------- -------------- 1 126.0 2010-08-01 2010-08-02 86400.0 1 144.0 2010-08-02 2010-08-03 86400.0 1 385.0 2010-08-03 2010-08-04 86400.0 1 96.0 2010-08-04 2010-08-05 86400.0 1 245.0 2010-08-05 2010-08-06 86400.0 1 211.0 2010-08-06 2010-08-07 86400.0 1 254.0 2010-08-07 2010-08-08 86400.0 1 171.0 2010-08-08 2010-08-09 86400.0 1 68.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.