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

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 ('gaussian')
  Accumulate ('id')
) AS dt ORDER BY id;

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 Arguments.