Burst Example: TimeInterval, SplitCriteria ('gaussian') - Teradata Vantage

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 from the attachment in the left sidebar.